Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add results of Loop into a Cursor

594008Oct 23 2007 — edited Nov 22 2007
Hi,

I am opening a cursor and looping through each row (it has a select query that queries based on the value of a column obtained from another cursor).

How can I add all the rows to a new cursor (along with the column value I am getting from the first cursor), as I want to return that to a java program.

Can I create a new cursor and add the final data to it (that contains all rows), if yes How do I do that?

Thanks,
Rommel.

Message was edited by:
rommelsharma
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2007
Added on Oct 23 2007
7 comments
904 views