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!

Adding records to SYS_REFCURSOR

antobayOct 8 2020

Please help, how do I add records to SYS_REFCURSOR.? I have a procedure to return as many records but because there are many blocks of codes in-between the pl/sql block, I can't use OPEN SYS_REFCURSOR FOR SELECT. I can only put this outside the loop hence it only returns the last record.
pkg_01.txt (1.76 KB)All I want to do is output sets of records to the calling program, if there is another way of doing it, I would be grateful.
Thanks

Comments
Post Details
Added on Oct 8 2020
13 comments
5,101 views