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 AUGUST 30, 2023
Applies to:
JDBC - Version 19.7 and laterInformation in this document applies to any platform.
Symptoms
After upgrading a 12.1.0.2 database to version 19.12, JAVA programs using the ojdbc6.jar (version 11.2.0.3 or 12.1.0.2) 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 12.1.0.2 database, the error is raised as expected.
Example:
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 12.1.0.2 database works as expected.
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 |