without specifying field names in oracle cursor

Dear Friends

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

Regards

Sathya Narayanan
sathyabalajiAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
For comparison purpose, as long as you aren't picky about the output, check out the code I wrote in another question:

http://www.experts-exchange.com/Database/Oracle/Q_26843082.html?#a34966249
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.