Thanks, but I know how to use bulk binds with dynamic sql. Its trivial. I may have missed this, but I read the doc pretty carefully...

These are not one column inserts or updates. Im going to haev up to 150 columns and 75 tables each of which is unique.

So I would some way to dynamically generate pl/sql table objects at run time. I know how to make a generator package. Its simple, but not sure how to use it. This is what I would do.

Its pseudocode

CREATE OR REPLACE PROCEDURE GENERATOR(p_flag IN VARCHAR2,
p_vartable OUT PL/SQL TABLE TYPE NO COPY) -- i would have one of these for each data type.

is


begin

if p_flag = 'VARCHAR2
p_variable := pl/sql table of VARCHAR2 type)
end if;

end;

problem is how do I handle that generation back in my main package. Ill need 1 table for each column. This is trivial in C++ and Java. Or am I looking in the wrong place? I dont think its possible to use dynamic arrays in pl/sql

Oracle LazyDBA home page