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.