Try it here
Subscribe
Oracle Exceptions

Oracle PLSQL 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

Admin on May 16, 2019 at 12:05 am


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



Post Comment

Comments( 0)

WEB TECHNOLOGY

Articles

×

Forgot Password

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