Jdbc/Oci Call to Java Stored Procedure with OUT Parameter Fails with Ora-03116 After Oracle Database/Client Upgrade to 10G (Doc ID 367963.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

JDBC - Version: 10.2.0.1
This problem can occur on any platform.

Symptoms

A java application connecting to 10g (10.1.0.3 and above) UTF8 database (with a UTF8 / AL32UTF8
NCharset), which calls a java stored procedure with an out parameter, defined with either %type or as a char fails with 10g JDBC-OCI client(s).

Exception in thread "main" java.sql.SQLException: ORA-03116: invalid buffer leng
th passed to a conversion routine
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:700)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:632)
at
oracle.jdbc.driver.T2CCallableStatement.execute_for_describe(T2CCallableStatement.java:847)
at
oracle.jdbc.driver.T2CCallableStatement.execute_for_rows(T2CCallableStatement.java:1010)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3076)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4273)
at Test10gEmp.main(Test10gEmp.java:23)



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms