PL SQL Programming Oracle PLSQL Tutorial

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>