JDBC Thin Driver 12.1.0.2.0 Fails with java.sql.SQLException: Numeric Overflow When Using an OUT Parameter
(Doc ID 2363567.1)
Last updated on AUGUST 25, 2021
Applies to:
JDBC - Version 12.1.0.2.0 to 12.2.0.0.0 [Release 12.1 to 12c]Information in this document applies to any platform.
Symptoms
Application running on top of WebLogic 10.3.6 using JDBC thin driver 11.2.0.3.0 JDBC 4.0 works without issues. After migration to WebLogic 12.2.1.1.0, the application fails with java.sql.SQLException: Numeric Overflow.
Exception stack:
java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:5140)
at oracle.jdbc.driver.NumberCommonAccessor.getLong(NumberCommonAccessor.java:873)
at oracle.jdbc.driver.OracleCallableStatement.getLong(OracleCallableStatement.java:3822)
at oracle.jdbc.driver.OracleCallableStatementWrapper.getLong(OracleCallableStatementWrapper.java:2787)
at Main.main(Main.java:36)
WebLogic 12.2.1.1 has JDBC driver 12.1.0.2.0, and it seems that the new JDBC driver 12.1.0.2 can not handle properly in out parameter of ROWTYPE in stored procedure while older JDBC driver 11.2.0.3 can work with it without issues.
The problem can be reproduced on demand.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |