Database Error Messages

ORA-06502

PL/SQL: value or conversion errorerror_info
  • error_info: A more detailed description of why the error occurred.

Cause

An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if you attempt to assign the value NULL to a variable declared NOT NULL, or if you attempt to assign an integer greater than 99 to a variable declared NUMBER(2).


Action

To resolve the issue, change the data, the way the data is manipulated, or the data variable declaration.