I'm using StoredProcedure to call a Oracle Stored Proc which as 10-11 in params and 2 out param which are Ref_Cursors.
Sample code is:
Now I get 1000 rows from my resultset. Each is a different Practice. I want to store this in a Collection of Practices.
The problem I'm getting is when I print out the values of each practice, I get the same value (that is the Name of the last row of the resultset returned )and the same name is printed out 1000 times, instead of 1000 different practice names. Can somebody help me in what I'm missing. It would be of great help