A
asgars
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??
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??