Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

Handling a custom exception

SQL> SQL> DECLARE   2    e_TooManyEmployee EXCEPTION;  -- Exception to indicate an error condition   3  BEGIN   4    RAISE e_TooManyEmployee;   5  EXCEPTION   6    WHEN e_TooManyEmployee THEN   7      DBMS_OUTPUT.put_line('e_TooManyEmployee');   8  END;   9  / e_TooManyEmployee PL/SQL procedure successfully completed. SQL>