Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Array to Reference Cursor?

Re: Array to Reference Cursor?

From: SJRII <sjrow_at_yahoo.com>
Date: 26 Sep 2006 14:49:36 -0700
Message-ID: <1159307376.074445.166060@m7g2000cwm.googlegroups.com>


I tried every combination I could think of without success.

Thanks - JR

Sybrand Bakker wrote:
> 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 Tue Sep 26 2006 - 16:49:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US