without specifying field names in oracle cursor
Posted on 2011-03-23
For Data Migration purpose, i need to compare various complex queries between source and target environments
I am getting out of memory error when bulk volume of transactions are involved.
If i check one primary key value in those complex queries using cursor, i will not get out of memory error
is it possible to display field values in cursor without specifiying fieldnames from cursor in dbms_output.put_line statement in oracle procedure ?
Please help me