Oracle Error PLS-00483: exception ‘string’ may appear in at most one exception handler in this block

Oracle Error Message

PLS-00483: exception ‘string’ may appear in at most one exception handler in this block

Reason for the Error

An exception appears in two different WHEN clauses (that is, two different exception handlers) in the exception-handling part of a PL/SQL block or subprogram.

Solution

Remove one of the references to the exception.