Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OracleCallableStatement and stored procedure

843854Jul 8 2002 — edited Aug 8 2002
Hello,


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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2002
Added on Jul 8 2002
2 comments
142 views