Re: Stored procedures (HELP ME !!!)

From: Scott Urman <surman_at_dlsun338.us.oracle.com>
Date: 1996/07/22
Message-ID: <4t0d5s$n1i_at_inet-nntp-gw-1.us.oracle.com>#1/1


In article <4sv30u$jm_at_client2.news.psi.net>, dmausner_at_brauntech.com (Dave Mausner) writes:
|> In article <31F0CC9F.9D_at_worlnet.fr>,
|> Jean-Marc ARZOUMANIAN <jmarzou_at_worlnet.fr> wrote:
|> >Q: Does anyone know how to write an Oracle 7.x stored procedure that returns
|> > a multiple result set ?
|>
|>
|> A: nobody knows how to do this in Oracle7 because there is no such feature.
|> best regards.

Sure there is. Cursor variables were introduced in 7.2 and enhanced in Oracle 7.3. Check out the PL/SQL, OCI and precompiler manuals.

|>
|> --
|> Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.



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 Mon Jul 22 1996 - 00:00:00 CEST

Original text of this message