wood burning stoves*
The moose likes JDBC and the fly likes Passing an integer array to a Oracle Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Passing an integer array to a Oracle Stored Procedure" Watch "Passing an integer array to a Oracle Stored Procedure" New topic
Author

Passing an integer array to a Oracle Stored Procedure

Ganapathi Srinivasan
Ranch Hand

Joined: Apr 18, 2001
Posts: 41
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Passing an integer array to a Oracle Stored Procedure
 
Similar Threads
Passing Array as a parameter to Stored procedures
Calling DB2 stored procedures
REF_CURSOR as IN parameter?
Stored Procedure
Change in forum