Hi
I have posted this issue before also.. If anybody done code to call stored proc having Array as one of its i/p parameter

While creating ArrayDescriptor throwing error. We are using WebspherPortal 512.
I am using Oracle 902 and the driver is thin.

I know the ConnectionPool is making the connection stale.. but not sure why.
the code works perfectly on WAS6.0


Any help will be appriciated.

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