• 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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!