Re: Can I Select data from Procedure/Function?

From: Spencer <spencerp_at_swbell.net>
Date: Tue, 30 Jan 2001 23:00:12 -0600
Message-ID: <lZMd6.445$nD1.8925@nnrp1.sbc.net>

"Diviner" <diviner_at_hknet.com> wrote in message news:3A7777F6.2C501F05_at_hknet.com...
> I have a complex Select statement and want to wrap it up.
> Does Oracle has any machanism for me to do this?
>
> Thank you very much.
> --
> Best regards,
> Diviner.
>

yes.

you can create a stored PL/SQL block (procedure or function) that defines a cursor for your complex select statement, and passes a "ref cursor" object back (as an argument or return value) to the caller. Received on Tue Jan 30 2001 - 23:00:12 CST