Oracle Error PLS-00485: in exception handler, ‘string’ must be an exception name

Oracle Error Message

PLS-00485: in exception handler, ‘string’ must be an exception name

Reason for the Error

An identifier not declared as an exception appears in an exception handler WHEN clause. Only the name of an exception is valid in a WHEN clause.

Solution

Check the spelling of the exception name and make sure the exception was declared properly.