File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
Author

Calling a stored procedure with an ARRAY

Bjorn Lundstrom
Greenhorn

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.
Sincerely
Bjorn Lundstrom
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling a stored procedure with an ARRAY