aspose file tools
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 RabbitMQ in Depth this week in the Open Source 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
Author

Java Object to PL SQL Object

Dipti Karnataki
Greenhorn

Joined: Apr 23, 2009
Posts: 3


Hi,

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.

Dipti


DAK
Ireneusz Kordal
Ranch Hand

Joined: Jun 21, 2008
Posts: 423
Please give versions of Oracle and JDBC driver you are using.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Object to PL SQL Object