Re: HELP: Can Oracle Strored Procs./Funcs. return Result Sets ?

I'm sorry I can't offer more detailed help, but

look into the use of refcursor variables (In the PL/SQL or SQLPlus Guides)

you can declare a ref to a cursor

pass the ref as an IN/OUT variable to a stored proc

and the proc can define and open the cursor

Hope this provides a useful pointer in the right direction...

Marc

Arman Ali Anwar <arman.anwar_at_mci.com> wrote in message news:375D95DF.C894B7F1_at_mci.com...
> TIA, and could you kindly send all replies to arman.anwar_at_wcom.com
>
> Arman.
>
Received on Tue Jun 08 1999 - 18:59:08 CDT