Build an anonymous block that will trigger an error. : Compile Error « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Compile Error

Build an anonymous block that will trigger an error.

    

SQL>
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL> 
SQL> DECLARE
  2
  3    
  4    my_string         VARCHAR2(1) := ' ';
  5    my_number         NUMBER;
  6
  7  BEGIN
  8
  9    
 10    my_number := TO_NUMBER(my_string);
 11
 12  END;
 13  /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 10


SQL>
SQL>
SQL>








Related examples in the same category

1.Check the error
2.Check error for procedure
3.Check error form stored procedure
4.PLS-00306: wrong number or types of arguments in call
5.PLS-00363: expression '3' cannot be used as an assignment target
6.Set the PLSQL_WARNING level to DISABLE:ALL
7.This example illustrates the PLS-483 error
8.This package will not compile because the specification and body do not match.
9.how DDL doesn't work with PL/SQL