OracleCallableStatement and stored procedure
843854Jul 8 2002 — edited Aug 8 2002Hello,
I'm using stored procedures with WSAD 4.0.3 and Oracle 8i.
It does not work with Connection Pool. I'm suprise because when I'm using manual connection, the same stored procedure works ....
The exact error is java.lang.ClassCastException: com.ibm.ejs.cm.proxy.OracleCallableStatementProxy
and here is the critical extract of my code :
Connection con = AccessBase.getConnection();
//AccesBase is connected to my DataSource
//here is the error :
OracleCallableStatement cs = (OracleCallableStatement)con.prepareCall("{? = call civilite.libelle()}");
cs.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);
cs.execute();
rs=cs.getCursor(1);
thank you in advance