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 -> Array to Reference Cursor?

Array to Reference Cursor?

From: SJRII <sjrow_at_yahoo.com>
Date: 25 Sep 2006 12:56:48 -0700
Message-ID: <1159214208.357670.99750@m7g2000cwm.googlegroups.com>


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 Received on Mon Sep 25 2006 - 14:56:48 CDT

Original text of this message

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