Re: Error with DBMS_SQL

Thanks, it works now!

I added the lines;

[code]

source_cursor varchar2 (32767);
.
.
dbms_output.put_line('INSERT STATEMENT: '|| source_cursor);
[code]

and I see that the insert is made.

I'll try with a range of tables, to see that the collection of data is inserted correctly, with data from multiple tables.

Now I would like to add a few lines to check if the record exists then update then insert otherwise, according to the case.

You'll have an example that you do this?

Thank you very much! Received on Wed Mar 20 2013 - 15:20:15 CET