Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

When the exception occurs, program control passes to the EXCEPTION block where the WHEN clause is examined for a matchi

If no matching exception is found, the exception is propagated to the enclosing block. SQL> SQL> BEGIN   2    DBMS_OUTPUT.PUT_LINE(1 / 0);   3  END;   4  / BEGIN * ERROR at line 1: ORA-01476: divisor is equal to zero ORA-06512: at line 2