Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

OTHERS Exception

You can use the OTHERS exception to handle all exceptions. SQL> BEGIN   2    DBMS_OUTPUT.PUT_LINE(1 / 0);   3  EXCEPTION   4    WHEN OTHERS THEN   5      DBMS_OUTPUT.PUT_LINE('An exception occurred');   6  END;   7  / An exception occurred PL/SQL procedure successfully completed. SQL>