The Others Exception Handler and Exception Guidelines.

The Others Exception Handler:

• The OTHERS exception is an optional EXCEPTION handling clause that traps unspecified exceptions.
• The OTHER should always be the last handler in the block.
• It is good programming practice to have an OTHERS handler at the top level of your program to ensure that no errors go undetected.

Exception Guidelines:

• Begin the EXCEPTION handling section of the block with the keywords EXCEPTION.
• Define several EXCEPTION HANDLERS, each with its own set of action for the block.
• Avoiding unhandled exceptions, this can be done via an OTHERS handler at the topmost level program.
• When an EXCEPTION occurs PL/SQL processes only one handle before leaving the block.