ORA-06502 PL/SQL: numeric or value error
Monday, December 17th, 2007
This error message is very tricky. Here, you can learn how to solve it.
The main cause that produces this message is that you are assigning a value NULL to a variable that does not admit it.
DECLARE
N1 number(2) NOT NULL :=20;
N2 number(2);
BEGIN
N1 := N2;
END;
Another possible cause is that you are assigning a number to a variable […]