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.
