aspose file tools*
The moose likes JDBC and the fly likes How to pass a collection to Stored Proc from Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to pass a collection to Stored Proc from Java" Watch "How to pass a collection to Stored Proc from Java" New topic
Author

How to pass a collection to Stored Proc from Java

Jaydeep Deshmukh
Ranch Hand

Joined: Sep 10, 2002
Posts: 31
Hi Folks,

I need to pass a collection of numeric ids to a stored procedure in Oracle from a Java program. How do I achieve this?

Thanks in Advance
Jaydeep
Makarand Parab
Ranch Hand

Joined: Dec 10, 2004
Posts: 121
Hi Jaydeep
Pass the collection of numeric id's as comma seperated one string, inside the procedure, enumerate the string.

Regards
MAkarand Parab
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to pass a collection to Stored Proc from Java