Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Iterating through array as input parameter to stored procedure.
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
![]() |
![]() |