ORA-06502: PL/SQL: numeric or value errorstring Cause: An arithmetic,numeric, string, conversion, or constraint error occurred.
For example, this error occurs if an attempt is made to assign the value NULLto a
variable declared NOT NULL, or if an attempt is made to assign an integerlarger
than 99 to a variable declared NUMBER(2). Action: Change the data, howit is manipulated, or how it is declared so that
values do not violate constraints.