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

[Quoted] Thanks cindy

The link provided answers to most of the problems that I have been experiecing with oracle's stored procedure.

Phil

"C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote in message news:3B749445.DB4253A0_at_rationalconcepts.com...
> 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 Sun Aug 12 2001 - 14:43:06 CEST