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

See:
http://osi.oracle.com/~tkyte/ResultSets/index.html and be sure to browse around the rest of that site. Also, browse the link provided by Jim.

Tom's a great guy who has always shown patience and details in the anwers he supplies.

enjoy,
cindy

Phil Goden wrote:

> 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 - 21:09:44 CDT