Re: can a PL/SQL procedure return multiple records ?
Date: 23 Nov 1994 17:57:11 GMT
Message-ID: <3avvpn$kkd_at_fido.asd.sgi.com>
Yes, you can. Use PL/SQL tables as out parameters to your stored procedure.
Michael Feldman
mfeldman_at_netcom.com
In article <Czp15y.62F_at_news.arco.com>, Erik Dahl <Dahl#m#_Erik_D_at_msmail.aai.arco.com> writes:
> In article <3ap339$kgs_at_godot.cc.duq.edu> Sy Jerry,
> SYJERRY_at_duq3.cc.duq.edu
> writes:
>
> >subject says it all. can I write a PL/SQL procedure (or function)
> >that will return multiple records ? (like a select returns multiple
> >rows)
> >
> >jerry
>
>
> Nope. You can return parameters. You could fill in a temp table with
> multiple records... Sybase stored procedures will work this way.
>
> :-)
>
>
> *---------------------------------->>><<<------------------------------*
> * Erik Dahl >< ARCO Alaska, Inc. *
> * E-Mail - lasedd_at_aai.arco.com >< ANO-963E (907) 263-4461 *
> * Compuserve - 72754,1315 >< Opinions expressed are my own *
> *---------------------------------->>><<<------------------------------*
Received on Wed Nov 23 1994 - 18:57:11 CET