Re: possible to return modified ref cursor?

On 18 Jun 2003 14:18:54 -0700, techguy_chicago_at_yahoo.com (Bomb Diggy) wrote:

> In PL/SQL, I would
>guess the nomenclature would be 'build a Collection of Types and
>return to caller via REF CURSOR'. (??)

No. Just create a globally temporary table, insert your data in the table and return the table in a ref cursor as a select * from tempoary table.
Of course, *after* a second opinion whether your select *really* needs to be torn apart, as it is probably not going to be more efficient, at least not without bulk fetches,

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 18 2003 - 17:26:38 CDT