ORA-6502 Research Events
(Doc ID 2911572.1)
Last updated on DECEMBER 03, 2024
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterOracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
PL/SQL - Version 10.2.0.1 and later
Information in this document applies to any platform.
Goal
ORA-6502 is an error similar to the following:
// *Cause: An arithmetic, numeric, string, conversion, or constraint error
// occurred. For example, this error occurs if an attempt is made to
// assign the value NULL to a variable declared NOT NULL, or if an
// attempt is made to assign an integer larger than 99 to a variable
// declared NUMBER(2).
ORA-6502 can occur intentionally in the following sample code:
ORA-6502 can often occur in user-made PL/SQL programs at unintentional times and is not easy to debug.
However, an event is provided that you can determine what value entered into a digit variable leading to the ORA-6502 occurrence.
This is useful for debugging user-made PL/SQL programs.
Solution
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
Goal |
Solution |
References |