Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I return a recordset from a stored procedure
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