Illegal conversion between character and number : Number to Char « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Number to Char

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>








Related examples in the same category

1.Converting a character formatted as currency to an integer value
2.Converting Numbers to Characters Formatted as a Numeric String
3.Expressing Your Work in Scientific Notation