This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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