Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

The OTHERS Exception Handler

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    WHEN OTHERS THEN   9      DBMS_OUTPUT.put_line('OTHERS');  10  END;  11  / e_TooManyEmployee PL/SQL procedure successfully completed. SQL>