Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Returning resultset from Stored proc
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
![]() |
![]() |