ORA error

ORA-06502

ORA-06502: PL/SQL: numeric or value error

Quick fix

Cause: A PL/SQL assignment or conversion failed: most often a string longer than the VARCHAR2 variable it is assigned to ("character string buffer too small"), a number too large for its precision, or text that is not a valid number.
Fix: Read the rest of the message and the line number in the error stack, then enlarge the variable (anchor it with %TYPE to the column) or fix the value being converted.

ORA-06502: value error – Variable too small for assigned value (check VARCHAR2 size).

Database