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