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 Java Object to PL SQL Object Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Java Object to PL SQL Object" Watch "Java Object to PL SQL Object" New topic

Java Object to PL SQL Object

Dipti Karnataki

Joined: Apr 23, 2009
Posts: 3


I have a requirement where I need to call a procedure which has five arguments and three are in and 2 are out.

The first parameter is of type TBL and has a corresponding OBJ type in data base, all the values of TBL type are varchar.

For this TBL type I am using a ArrayDescrptor and for OBJ using StructDescriptor.

once this is done setting the values of Object[] to User's Strings and passing to new STRUCT , the struct which I get from this I am passing to ARRAY and this is giving me a

Internal Representation Error.

while creating ARRAY object. If I am directly passing STRUCT object to cstcmt.setObject , it is giving me invalid number or type of arguments.

I have to complete this very urgently. Please help me with this. If any one has good knowledge on this may be we can have a call or webex.

Thanks in advance.


Ireneusz Kordal
Ranch Hand

Joined: Jun 21, 2008
Posts: 423
Please give versions of Oracle and JDBC driver you are using.
Don't get me started about those stupid light bulbs.
subject: Java Object to PL SQL Object
It's not a secret anymore!