<div>
<div class="content wysiwyg-content">
Dear Friends<br />
<br />
For Data Migration purpose, i need to compare various complex queries between source and target environments<br />
<br />
I am getting out of memory error when bulk volume of transactions are involved.<br />
<br />
If i check one primary key value in those complex queries using cursor, i will not get out of memory error<br />
<br />
is it possible to display field values in cursor without &nbsp;specifiying fieldnames from cursor in dbms_output.put_line statement in oracle procedure ?<br />
<br />
Please help me <br />
<br />
Regards<br />
<br />
Sathya Narayanan
</div>
</div>


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

without specifying field names in oracle cursor

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.