DYNAMIC REF CURSORS Possible?

From: David LeJeune <dlejeune_at_yahoo.com>
Date: 18 Dec 2001 17:31:33 -0800
Message-ID: <f329f8a7.0112181731.18715060@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.

thanks in advance,
=-Dave. Received on Tue Dec 18 2001 - 19:31:33 CST