Win a copy of Mesos in Action this week in the Cloud/Virtualizaton 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
Hi,
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!!
Thanks,
Ganapathi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic