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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Returning resultset from Stored proc

Re: Returning resultset from Stored proc

From: Chris Webb <chris.c.webb_at_x400.icl.co.uk>
Date: 2000/02/29
Message-ID: <38BBCCF8.96AECBC8@x400.icl.co.uk>#1/1

If the result set is small you can define a PL/SQL table and return the values in that.

kev wrote:

> Hi,
>
> I want to write a stored procedure which will perform a query and return
> the result. I know how to return values via IN OUT variables, but can I
> return a whole resultset?
> Example code would be appreciated, the simpler the better.
>
> thanks,
>
> - Kev
Received on Tue Feb 29 2000 - 00:00:00 CST

Original text of this message

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