Mega Code Archive
Number that exceeds precision
SQL>
SQL> DECLARE
2 v_TempVar NUMBER(2);
3 BEGIN
4 v_TempVar := 456;
5 END;
6 /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at line 4
SQL>