Unanswered: how load data using stored procedures?
I want to load into a table a lot of records using stored procedures. For example I have this table:
test_table (id number, name varchar2(24), address varchar2(64))
The procedure is something like that:
Create procedure load_data(collection) is
for each data from collection loop
Insert into test_table values(sequence.nextval, collection.name, collection.adress)
It is possible to have a stored procedure witch have as parameter a collection or something like this.? I what to call this procedure from Visual Basic and I want to parsing more than one name and address for each call.
The requirement is to don’t use external utility like sqlloader. My solutions are unreliability?.
Can you be more explicitly how to use VARRAYS using my example? The parameter for procedure must by VARRAYS type?
FOR I IN 1 .. 22
if c_parameter_name(I) is not null AND c_parameter_name(I) <> 'NULL' AND
c_parameter_name(I) <> ' '
INSERT INTO tablename (PARAMETERNAME,...
values (TRIM(C_PARAMETER_NAME(I)), ....