Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DYNAMIC REF CURSORS Possible?
Ganesh -
I did look at the documentation but it seemed as though you were required to perform some type of query to populate the ref cursor. Although you can used a weak typed ref cursor and have a dynamic query to populate it you still have to perform a query. My question is is I can build it manually through code and return it to the calling procedure to make it really seem like a cursor is being returned.
=-Dave.
ganesh_at_gtfs-gulf.com (Ganesh Raja) wrote in message news:<a8aed4.0112182336.1ddf5ccc_at_posting.google.com>...
> dlejeune_at_yahoo.com (David LeJeune) wrote in message news:<f329f8a7.0112181731.18715060_at_posting.google.com>...
> > Hi -
> >
> > Quick question. Is there a way to BUILD a cursor within a PL/SQL
> > stored procedure? We have some C++ libs making calls thru OCI and we
> > return cursors with data to them.
> >
> > We have one procedure where we loop and generate what could be a
> > cursor - but is not a query. We'd like to build the cursor
> > dynamically and then return it. However, it seems like the only way
> > to do it would be to create a temporay table, insert rows and then
> > query those rows to return the cursor.
> >
> > There must be an easier way.
>
> The Easier way is to use ref Cursors ... Check out the documention on ref Cursor.
>
>
>
> >
> > thanks in advance,
> > =-Dave.
>
> Regards,
> Ganesh R
Received on Wed Dec 19 2001 - 09:05:15 CST