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!

Collection of records into a SYS_REFCURSOR

545948Nov 27 2006 — edited Dec 1 2006
Hi everyone.

I have a stored proc that updates a table through the use of a loop. Each row that is updated is then placed into a collection of records. Once complete I have this collection of records representing the updated rows. I need to output this data as a SYS_REFCURSOR. Is there an easy way to place a collection of records into a SYS_REFCURSOR? I have not found much help online, and the books I have do not go in-depth enough on collections and ref cursors.

Thanks!

Just a note, the SYS_REFCURSOR is out put to a .NET web service which will make use of the data.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2006
Added on Nov 27 2006
7 comments
905 views