Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ResultSet from Stored Procedure

Re: ResultSet from Stored Procedure

From: Luciano Belotto <luciano_at_nospam.com>
Date: 24 Jun 2002 21:25:10 GMT
Message-ID: <af82nm$jfi@dispatch.concentric.net>


urgh... ignore dupe post.

"Luciano Belotto" <luciano_at_nospam.com> wrote in message news:af82l8$jep_at_dispatch.concentric.net...
> I guess what I'd like is just a simple example on how to do it. All I see
on
> that previous example is him selecting a cursor then returning the
reference
> to it. How would I go about modifying it? Do I fetch records out of the
> cursor then modify them? Then how do i get those modified records into
> another resultset to return?
> --
> Luciano Belotto
> replace spam with traxsoftware for e-mail
>
>
> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3D177CA3.58E7FB1A_at_exesolutions.com...
> > Luciano Belotto wrote:
> >
> > > sorry for extra posts.
> > >
> > > "Luciano Belotto" <luciano_at_nospam.com> wrote in message
> > > news:af7rgv$h0o_at_dispatch.concentric.net...
> > > > I've read the article at
> > > http://osi.oracle.com/~tkyte/ResultSets/index.html
> > > > but it only shows examples of returning a ResultSet which is a
cursor
> > > (which
> > > > itself was from a select)
> > > >
> > > > What I'd like to do is have a result set, then do some manipulations
> on
> > > that
> > > > data inside the stored procedure itself, then return the modified
> > > resultSet.
> > > > Can anyone give a simple example of this?
> > > >
> > > > --
> > > > Luciano Belotto
> > > > replace spam with traxsoftware for e-mail
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> >
> > What is preventing you from modifying the values in the REF CURSOR
before
> > returning it?
> >
> > Daniel Morgan
> >
>
>
Received on Mon Jun 24 2002 - 16:25:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US