• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

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
0
sathyabalaji
Asked:
sathyabalaji
1 Solution
 
slightwv (䄆 Netminder) 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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now