Win a copy of Kubernetes in Action this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Passing an integer array to a Oracle Stored Procedure  RSS feed

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
Boost this thread!