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

Oracle Error Message

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

Reason for the Error

One or more exception handlers appear after an OTHERS handler. However, the OTHERS handler must be the last handler in a block or subprogram because it acts as the handler for all exceptions not named specifically.

Solution

Move the OTHERS handler so that it follows all specific exception handlers.