File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
jQuery in Action, 3rd edition
subject: Calling a stored procedure with an ARRAY
It's not a secret anymore!