Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Returning a REF CURSOR in a Function?
Oracle 8.1.7, NT 4.0 no Java Option Installed.
I have a PL/SQL Package and within one of the procedures in the body, it return a REF CURSOR (p_Cursor). For simplicity sakes, it looks like:
open p_Cursor for
select col1 from table_Foo where col2 in (select thatValue from table_Bar where date < SYSDATE and dept = 'SALES');
is it possible to have the "in" piece be a function that returns a ref cursor to the ref cursor? as in...:
open p_Cursor for
select col1 from table_Foo where col2 in fn_getThatValues(SYSDATE, 'SALES');
Any help woule be appreciated.
Thanks,
Sean
Sent via Deja.com
http://www.deja.com/
Received on Fri Feb 02 2001 - 13:00:59 CST