Try it here
Oracle Exceptions

Oracle PLSQL Exceptions


What is an Exception :

An Exception is a run-time error or warning condition, which can be predefined or user-defined. Predefined exceptions are raised implicitly(automatically) by the runtime system. User-defined exceptions must be raised explicitly by RAISE statements.

What will happen if we write WHEN OTHERS before other exceptions?

The WHEN OTHERS clause must be the last exception handler in the exception section. If you place any other WHEN clauses after WHEN OTHER, you will receive the following compilation error :

PLS-00370 : OTHERS handler must be last among the exception handlers of a block

Writer profile pic

Uk01 on May 16, 2015 at 12:05 am

If you like and would like to contribute, you can write your article here or mail your article to . See your article appearing on the main page and help others to learn.

Post Comment

Comments( 0)


Forgot Password

Please enter your email address below and we will send you information to change your password.