Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Returning a REF CURSOR in a Function?

Returning a REF CURSOR in a Function?

From: Sean <dolans_at_my-deja.com>
Date: Fri, 02 Feb 2001 19:00:59 GMT
Message-ID: <95f054$ek4$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US