SQL>
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL> -- Build an anonymous block that will trigger an error.
SQL> DECLARE
2 -- Define local variable.
3 my_string VARCHAR2(1) := ' ';
4 my_number NUMBER;
5
6 BEGIN
7 my_number := TO_NUMBER(my_string);
8
9 END;
10 /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 7
SQL>