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 -> Iterating through array as input parameter to stored procedure.

Iterating through array as input parameter to stored procedure.

From: <asgars_at_gmail.com>
Date: 5 Jun 2006 09:26:20 -0700
Message-ID: <1149524780.878627.95920@i40g2000cwc.googlegroups.com>


Hi,
I am passing an array into a stored procedure. Now i want to iterate through this array. This can very well be done by For Loop. But my problem is:
I have to run the SELECT query based on each element in array (i.e. as many times as the number of elements in the array) and i want to accumulate all the rows retreived from each query into a cursor so that i can get it into a Dataset finally.
I am stuck as donno how to proceed in this.... Please can anyone help..?

Or is there a better way to do it?? Received on Mon Jun 05 2006 - 11:26:20 CDT

Original text of this message

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