Collection of records into a SYS_REFCURSOR
545948Nov 27 2006 — edited Dec 1 2006Hi 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.