Title: Dynamic cursor in PL/SQL
Hi gurus,
I have to do a stored proc to compare the data of two tables in different schemas. I want to use a dynamic cursor and select the content of a table passed in argument.
I saw in a document that I can work with REF CURSOR like this instance
Try: -
schema_table := 'DIFF';
open schema_comp for
'select * from ' || schema_table;
HTH
David Lord
-Original Message-
Sent: 17 August 2001 11:46
To: Multiple recipients of list ORACLE-L
Hi gurus,
I have to do a stored proc to compare the data of two tables in different