Re: ResultSet from Stored Procedure

Luciano Belotto wrote:

> 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
> >

If you create your cursor with something like:

OPEN cvar FOR

   SELECT col1, col2
   FROM .... Then cvar.field_name can be changed as in:

   cvar.field_name := some_other_value;

Just like with a static cursor.

Daniel Morgan Received on Mon Jun 24 2002 - 15:48:38 CDT