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_at_news1.sttls1.wa.home.com>


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

Jim

[Quoted] [Quoted] "Phil Goden" <noble_at_audiophile.com> wrote in message [Quoted] 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 Sat Aug 11 2001 - 03:42:23 CEST

Original text of this message