Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Passing an integer array to a Oracle Stored Procedure

Ganapathi Srinivasan
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a pecuilar problem. I need to pass an array of integers to an oracle stored procedure so that I can loop through every integer in the array and update fields in a table (whose primary keys are present in the array). Is it possible? If yes, can someone give a sample code(JDBC as well as stored procedure end)
Else I might have to loop through every element in the array from Java end and give JDBC calls to the stored procedure which I think might be really really costly !!
Any help..This is pretty urgent!!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic