Re: Executing a stored proc and getting a result set?
Date: 1996/09/18
Message-ID: <51pfe2$mt2_at_inet-nntp-gw-1.us.oracle.com>#1/1
In article <fsp8lix28.fsf_at_elastica.com>, robert_at_elastica.com writes:
|> 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?
Use Oracle 7.2 or higher, where the cursor variable feature has been implemented. A stored procedure returns a cursor variable, and the client program then fetches from it. The client program can be SQL*Plus, Pro*C, or OCI.
|>
|> Something about selecting from DUAL but I don't quite understand.
|>
|> --
|> Art is prostitution of the mind.
Scott Urman Oracle Corporation surman_at_us.oracle.com
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2 Published by Oracle Press - http://www.osborne.com/oracle/index.htm
"The opinions expressed here are my own, and are not necessarily that of Oracle Corporation"
Received on Wed Sep 18 1996 - 00:00:00 CEST