Re: Executing a stored proc and getting a result set?

From: Ola and Claude <cdaoust_at_ns.net>
Date: 1996/09/17
Message-ID: <01bba440$7a36e220$a5f077cc_at_ns.ns.net>#1/1


Oracle 7.2 and up allow the use of cursor vars to pass result sets from sp's.

hth

robert_at_elastica.com wrote in article <fsp8lix28.fsf_at_elastica.com>...
> Hi, I have to execute a stored proc that's been written to
> accept output parameters and so therefore doesn't output
> it's results via a resultset.
>
> Is it true that Oracle 7 can only return one row in a resultset
> of a stored proc?
>
> What do I have to do in order to execute the stored proc such that
> it's output will be able to be "fetched" from the result set?
>
> Something about selecting from DUAL but I don't quite understand.
>
> --
> Art is prostitution of the mind.
>
Received on Tue Sep 17 1996 - 00:00:00 CEST

Original text of this message