A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Java Object to PL SQL Object
Joined: Apr 23, 2009
Jan 20, 2012 05:23:33
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.
Joined: Jun 21, 2008
Jan 20, 2012 09:40:38
Please give versions of Oracle and
driver you are using.
I agree. Here's the link:
subject: Java Object to PL SQL Object
Why it is not 'null' ?
[newbie] invoking methods within a class (java.lang.reflect)
Passing an array into a vararg method (in Reflection API)
Sending null value to db
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015