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

I have looked at these newsgroups and have looked in several books but non seems to address my question. Stored procedures seems to only get half a page in all the books I have looked at so far.

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:340d7.426339$p33.8455958_at_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:59:02 CDT