Passing an integer array to a Oracle Stored Procedure
posted 15 years ago
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