Re: Fetch SYS_REFCURSOR with unknown structure?

<seanbrasher_at_gmail.com> wrote in message news:1142031431.473424.66890_at_j52g2000cwj.googlegroups.com...
: On this page
: http://www.adp-gmbh.ch/ora/sql/sys_refcursor.html
:
: it shows a function that accepts a SYS_REFCURSOR as a parameter and
: then does a
: DBMS_OUTPUT loop to write the values from that cursor.
:
: I need to write a function that will work the same way, but when I do
: *not* know the
: structure of the SYS_REFCURSOR ahead of time. 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?
:

haven't tried it or seen it done, but i think it may be possible using ANYTYPE, ANYDATA, and ANYDATASET types

++ mcs Received on Sat Mar 11 2006 - 06:11:08 CST