wood burning stoves 2.0*
The moose likes JDBC and the fly likes Calling a stored procedure with an ARRAY Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Calling a stored procedure with an ARRAY" Watch "Calling a stored procedure with an ARRAY" New topic

Calling a stored procedure with an ARRAY

Bjorn Lundstrom

Joined: Oct 01, 2000
Posts: 6
Hi all!
I hope there is someone out there who could help me with this(for me diffcult, for others probably simple) assignment.
I would like to call a stored procedure in Oracle with an array. According to specs I must first create an ArrayDescriptor in order to create an ARRAY object. But, since I don't have any connection object at this time, I can not create the ArrayDescriptor and of course, no ARRAY.
So, in order to use java.sql.Types.ARRAY(which corresponds to oracle.sql.ARRAY) is there any way to access the db than using oracle.sql.ARRAY?
I might be way of target by these ideas, but I sure hope someone can push me in the right direction.
Bjorn Lundstrom
wood burning stoves
subject: Calling a stored procedure with an ARRAY
Similar Threads
Stored Procedure and Java
trouble passing array to stored procedure in spring HELP
Stored procedure which returns array
Problem while setting multiple Oracle Arrays as input to a proc
cannot create oracle.sql.ArrayDescriptor using connection from weblogice datasource