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 AUGUST 30, 2023

Applies to:

JDBC - Version 19.7 and later
Information 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


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