Re: Array to Reference Cursor?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 25 Sep 2006 23:08:57 +0200
Message-ID: <48hgh29nqdk7b0o9ntta3eucrugmk2g6sk@4ax.com>

On 25 Sep 2006 12:56:48 -0700, "SJRII" <sjrow_at_yahoo.com> wrote:

>I have a procedure that will return N-rows from a table via a reference
>cursor.
>
>I have been unable to figure out a syntax that will let me return the
>array from a BULK COLLECT as a reference cursor unless I loop through
>the array loading the Object Type that the ref cursor requires.
>
>Is there anyway to directly from the array to a ref. cursor?
>
>Thanks - JR

Search for the TABLE and CAST operators either in the docs or on http://asktom.oracle.com (if the airco of the server room has been replaced already)

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Sep 25 2006 - 16:08:57 CDT