Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling a stored procedure with an ARRAY

 
Bjorn Lundstrom
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic