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 - 15:42:51 CDT
