Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Array to Reference Cursor?
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
![]() |
![]() |