My Oracle Support Banner

ORA-6502 Research Events (Doc ID 2911572.1)

Last updated on JULY 20, 2024

Applies to:

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


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