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.
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
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.