Oracle Error Message
ORA-06502: PL/SQL: numeric or value errorstring
Reason for the Error
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).
Solution
Change the data, how it is manipulated, or how it is declared so that values do not violate constraints.