We are trying to create stored proc which has Array as one of its parameter.
To create java.sqlAtrrayDescriptor we are using
descriptor
= (ArrayDescriptor) WSCallHelper.jdbcPass(
ArrayDescriptor.class,
"createDescriptor",
new Object[] {arrayName, aConnection},
new Class[] {java.lang.String.class, Connection.class},
new int[]{WSCallHelper.IGNORE,WSCallHelper.CONNECTION, WSCallHelper.IGNORE}
);
------------------------------------------------------------------------
The portal and oracle version we use is
wps5102
oracle 9207
----------------------------------------------------------------------

We are getting following exception

Caused by: java.sql.SQLException: No more data to read from socket
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine. java(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine. java(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.Oclose.receive(Oclose.java(Compil ed Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.TTC7Protocol.close(TTC7Protocol.j ava(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OracleStatement.close(OracleSta tement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.private Close(OraclePreparedStatement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.close(O raclePreparedStatement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OracleCallableStatement.close(O racleCallableStatement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.oracore.OracleTypeADT.initMetadata(Ora cleTypeADT.java:590)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeA DT.java:407)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.sql.ArrayDescriptor.initPickler(ArrayDescri ptor.java:1952)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.sql.ArrayDescriptor.(ArrayDescriptor.java:199)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.sql.ArrayDescriptor.createDescriptor(ArrayD escriptor.java:118)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at java.lang.reflect.Method.invoke(Method.java(Compil ed Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.jdbcPass(WSJd bcUtil.java:747)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at com.ibm.websphere.rsadapter.WSCallHelper.jdbcPass( WSCallHelper.java:379)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R ... 258 more
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R Caused by: SQLState(null) vendor code(17410) java.sql.SQLException: No more data to read from socket
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.dbaccess.DBError.check_error(DBError.j ava(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine. java(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine. java(Inlined Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.Oclose.receive(Oclose.java(Compil ed Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.ttc7.TTC7Protocol.close(TTC7Protocol.j ava(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OracleStatement.close(OracleSta tement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.private Close(OraclePreparedStatement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OraclePreparedStatement.close(O raclePreparedStatement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.driver.OracleCallableStatement.close(O racleCallableStatement.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.oracore.OracleTypeADT.initMetadata(Ora cleTypeADT.java:590)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeA DT.java:407)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.sql.ArrayDescriptor.initPickler(ArrayDescri ptor.java:1952)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.sql.ArrayDescriptor.(ArrayDescriptor.java:199)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at oracle.sql.ArrayDescriptor.createDescriptor(ArrayD escriptor.java:118)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java(Compiled Code))
[2/13/07 9:41:08:938 EST] 69a1c7ef SystemErr R at java.lang.reflect.Method.invoke(Method.java(Compil ed Code))