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.
