Raises and manages a standard anonymous block PL/SQL program error. : Raise « PL SQL « Oracle PL / SQL






Raises and manages a standard anonymous block PL/SQL program error.

    
SQL>
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL> 
SQL> DECLARE
  2
  3    
  4    my_error          EXCEPTION;
  5
  6  BEGIN
  7
  8    
  9    RAISE my_error;
 10
 11  EXCEPTION
 12
 13    WHEN others THEN
 14      dbms_output.put_line('RAISE my_error'||CHR(10)||'SQLCODE ['||SQLCODE||']'||CHR(10)||'SQLERRM ['||SQLERRM||']');
 15
 16  END;
 17  /
RAISE my_error
SQLCODE [1]
SQLERRM [User-Defined Exception]

PL/SQL procedure successfully completed.

SQL>

   
    
    
    
  








Related examples in the same category

1.Raise your own exception
2.Raising an exception
3.Raising NO_DATA_FOUND Exception
4.RAISE_APPLICATION_ERROR
5.Raise different exception depends on value input
6.Raise exceptions for wrong parameters
7.Print out an error message
8.This procedure demonstrates the use of RAISE_APPLICATION_ERROR.
9.Setting the message dynamically