Re: How do I return a recordset from a stored procedure

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sat, 11 Aug 2001 01:42:23 GMT
Message-ID: <340d7.426339$p33.8455958@news1.sttls1.wa.home.com>

Have you tried to look in this newsgroup or any of the documentation? This question is asked almost daily and answered frequently. Have you looked on MetalLink? or http://asktom.oracle.com?

Jim

"Phil Goden" <noble_at_audiophile.com> wrote in message news:HL%c7.16514$tq.1808338_at_news6-win.server.ntlworld.com...
> Hello,
>
> I am new to Oracle. I am trying to return the result of a simple query
> through a stored procedure.
>
> What I have inside the stored procedure look like this:
>
> select * from table_a where field1 = 'value'
>
> When I execute the stored procedure from SQLPlus, I would like the result
to
> look as though I had execute the select statement directory.
>
> Can anyone help?
>
> ---
> Phil
>
>
Received on Fri Aug 10 2001 - 20:42:23 CDT