Register / Login
JDBC and Relational Databases
Setting Array of String to callable statement ?
posted 7 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%
setArray(...) in DB2
Apache Commons DBCP connection object problem
a little confused!
Conditional 'where' condition