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 22.214.171.124 database to version 19.12, JAVA programs using the ojdbc6.jar (version 126.96.36.199 or 188.8.131.52) 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 184.108.40.206 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 220.127.116.11 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