Re: DYNAMIC REF CURSORS Possible?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 18 Dec 2001 23:36:57 -0800
Message-ID: <a8aed4.0112182336.1ddf5ccc@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 - 01:36:57 CST