RE: reference cursors

After playing around some, it looks like when the select is opened via a
refcursor, the hints don't work.  If I create a global temporary table, have
the select table dump its load into the temporary table, then open the
refcursor as select * from the temporary table, everything moves right along
again.  In more detail (because I'm playing around with this stuff): I
created a row type, then created a table type, then create a variable of
that table type; then do a bulk select into the table type variable.  Now I
wish to hell there was a way to pass a pointer to that table type variable
as the refcursor, but I couldn't figure out a way.  So I did a loop to
insert the rows of the table type variable into the temporary table; then do
the refcursor on the temporary table.  I don't know if I will actually
suggest this as a "solution". It's kind of Rube Goldberg-y and is bound to
complicate application maintenance .. which is the last thing in the world
this application needs.

Anybody got any better ideas (other than re-write the app)?  If there is a
way to pass a pointer to the table type variable without having to use the
temporary table gadget, I'm all ears.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: