It depends on the database you are using.
If using oracle, then you can create a new datatype in database to store
array of numbers(if you require to work with
Collection of number)
Then you can pass a array of numbers to stored proc using the setArray
method
The code snippet is as follows:
-
java.sql.Array?
CRANFORD, CHRIS wrote:
Is there a proper way to pass an arraylist/collection to a pl/sql procedure
besides turning it into a string on the java-side and passing it then as a
VARCHAR parameter?
___
Chris Cranford
Programmer/Develope
2 matches
Mail list logo
