aspose file tools*
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
Problem while setting multiple Oracle Arrays as input to a proc
cannot create oracle.sql.ArrayDescriptor using connection from weblogice datasource
trouble passing array to stored procedure in spring HELP
Stored Procedure and Java
Stored procedure which returns array