My Oracle Support Banner

JDBC Thin Driver 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 to [Release 12.1 to 12c]
Information in this document applies to any platform.


Application running on top of WebLogic 10.3.6 using JDBC thin driver JDBC 4.0 works without issues. After migration to WebLogic, the application fails with java.sql.SQLException: Numeric Overflow.


Exception stack:

java.sql.SQLException: Numeric Overflow
  at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(
  at oracle.jdbc.driver.NumberCommonAccessor.getLong(
  at oracle.jdbc.driver.OracleCallableStatement.getLong(
  at oracle.jdbc.driver.OracleCallableStatementWrapper.getLong(
  at Main.main(

WebLogic has JDBC driver, and it seems that the new JDBC driver can not handle properly in out parameter of ROWTYPE in stored procedure while older JDBC driver can work with it without issues.

The problem can be reproduced on demand.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.