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_at_freelists.org
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
Received on Thu Jan 29 2004 - 23:04:59 CST
