Problem while calling stored procedure using jdbc adapter connection

, ,
1

Hi,

my requirement is to invoke a stored procedure by java service.
I am able to get the jdbc connection using ExecuteService in the java service but when i create the object of OracleCallableStatement using below statement:

oracle.jdbc.driver.OracleCallableStatement cs = (oracle.jdbc.driver.OracleCallableStatement)conn.prepareCall( sql ); – sql is a procedure name string

then found following error:

java.lang.ClassCastException: oracle.jdbc.driver.T4CCallableStatement

Please let me know how can i execute the procedure successfully.

2

This might be a problem with ur jar files(ojdbc14.jar). Please check that part once.

~R

3

Hi,

This might be because of ur ojdbc14.jar files, please check that part once.

~R