My Oracle Support Banner

ORA-06502 Not Raised With JDBC 11.2 or 12.1 Drivers When Connected To A 19.12 Database (Doc ID 2859243.1)

Last updated on APRIL 04, 2022

Applies to:

JDBC - Version 19.7 and later
Information in this document applies to any platform.


After upgrading a database to version 19.12, JAVA programs using the ojdbc6.jar (version or with JDK 1.6 do not report "ORA-06502: PL/SQL: numeric or value error" as expected .

The issue arises when using a custom type parameter in the PLSQL function. The type contains an array of another custom type.

If the same JAVA programs are run against a database, the error is raised as expected.




If an object <OBECT TYPE 2> has an <ATTRIBUTE TYPE 2> more than 100, the PLSQL function should return ORA-06502 error which is not seen by the java program.

The same scenario with a database works as expected.




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.