Problem in Bulk insert over a dblink

[sumanroyc]

Hi,

We are trying to insert into a remote database using the forall statement 5000 rows at a time.
type t_column_id is table of number index by binary_integer;
v_column_id t_column_id;
begin
open my_cur;
loop
fetch my_cur bulk collect into v_column_id limit 5000;


forall i in 1..v_column_id.count
execute immediate
'insert into ' || w_table_name || '_bulk' || '@' || in_db_link || ' select * from ' || w_table_name || ' where ' || w_primary_key || ' = :1' using v_column_id(i);

exit when my_cur%notfound;

end loop;
close my_cur;
commit;
end;


However no insertions are taking place in the remote db. We checked using a normal cursor for loop and in that case the inserts are happening fine. Also no exceptions are reported in either case.

Please let us know if we are missing something here.

We are using Oracle version 9.2.0.6.0 .

Thanks & Regards,
Suman.

[kwame2]

you used a so called cursor my_cur but you don't declare it before ; if you didn't put it on the forum may be for doing short, verify that its content is wellformed and correspond to what is in your collection table declared before.
good luck!!!
Robert.