Re: can a PL/SQL procedure return multiple records ? NO

From: Michael Feldman <mfeldman_at_mosaic.engr.sgi.com>
Date: 9 Dec 1994 23:48:45 GMT
Message-ID: <3caqct$oo8_at_fido.asd.sgi.com>


Incorrect. Use a PL/SQL table as an out parameter. I've done it. It works.

Michael

In article <James.Lawrence.58.000C2004_at_epamail.epa.gov>, James.Lawrence_at_epamail.epa.gov writes:
> In article <3c5o6f$3vf_at_newsbf01.news.aol.com> slurton_at_aol.com (Slurton) writes:
> >From: slurton_at_aol.com (Slurton)
> >Subject: Re: can a PL/SQL procedure return multiple records ?
> >Date: 7 Dec 1994 20:40:31 -0500
>
> I understood the question to be: could you return mutiple records to the
> process that called the procedure? In other words, as return values from the
> procedure. You cannot do that. For example if you write a procedure to get
> customer data it can only return one customer at a time, not sets of customers.
>
> Lawrence....
Received on Sat Dec 10 1994 - 00:48:45 CET

Original text of this message