How do I fix ORA-06502 error?
How do I fix ORA-06502 error? You can correct this error by assigning the variable called v_number a proper numeric value. SQL> CREATE OR REPLACE PROCEDURE TestProc 2 AS 3 v_number number(2); 4 BEGIN 5 v_number := ASCII(‘a’); 6 END; 7 / Procedure created. And now when we execute our TestProc procedure, the ORA-06502 error […]