Mega Code Archive
Illegal conversion between character and number
SQL>
SQL> DECLARE
2 v_TempVar NUMBER;
3 BEGIN
4 v_TempVar := 'xyz';
5 END;
6 /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 4
SQL>
SQL>