Register / Login
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
JDBC and Relational Databases
Setting Array of String to callable statement ?
posted 8 years ago
I want to set array of
to callable statement .
with OracleCallable statement it is easy to do with the help of cstmt.setARRAY()
but i with normal callable statement though it provides us serArray() but we have to create ARRAY object with the help if ArrayDesriptor() which again takes connection io its constructor ...
and it works only if your connection is oracleConnection
but if your connection is other than that OracleConnection (WSJdbcConnection) then it says classcast exception
so i cant use ArrayDescriptor method ...
Is there any other way of pass array to callable statment
Thanks in Advance
SCJP 88% SCWCD 88%SCBCD 88%
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
Boost this thread!
setArray(...) in DB2
Apache Commons DBCP connection object problem
a little confused!
Conditional 'where' condition