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.