Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Result Set as Return Value ?

Re: Result Set as Return Value ?

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Fri, 02 May 2003 20:21:23 GMT
Message-ID: <MPG.191c731dfc423395989766@news.la.sbcglobal.net>


georg.scholz_at_vienna.at said...
> Dear all,
>
> is it prossible to write a stored procedure which returns the result set of
> a SELECT - Statement?
>
> Just looked through the manuals and found datatyes "RECORD" or "DATASET". -
> Can these be used for this purpose?
>
> Thanks in advance
>
> Georg Scholz
> www.scholz-informatik.at
>

Head over to http://asktom.oracle.com/ and search for "ref cursor" ... you'll find lots of help and examples.

-- 
/Karsten
DBA > retired > DBA
Received on Fri May 02 2003 - 15:21:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US