• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Spring StoredProcedure + RowMapper issue

 
Harry Dhina
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All

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:

RowMapper:



StoredProc:



Now I get 1000 rows from my resultset. Each is a different Practice. I want to store this in a Collection of Practices.

Main Prog:



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


Thanks

Harry
 
Hong Anderson
Ranch Hand
Posts: 1936
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What you do in proc.execute(params)?
 
Harry Dhina
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Kengkaj Sathianpantarit wrote:What you do in proc.execute(params)?



I execute the StoredProcedure by passing the IN params....
 
Hong Anderson
Ranch Hand
Posts: 1936
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you post proc.execute source code?
Have you tried run this store procedure or debugged MyRowMapper.mapRow?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic