I have written a procedure that accepts a SYS_REFCURSOR as an input
parameter and writes out the contents of that cursor using a FETCH and
DBMS_OUTPUT. This works great as long as you know the structure of the
cursor ahead of time.
I need to write a function that will work when I do not know the
structure of the SYS_REFCURSOR. That means that I do not know what kind
of variables to FETCH the cursor into. Is there some way to fetch the
cursor into an array or generic table object, and then loop through
that object to do the DBMS_OUTPUT step?
Received on Fri Mar 10 2006 - 16:41:21 CST
