How to fix the Oracle error PLS-00233: function name used as an exception name in when clause?

In this post, you’ll learn more about the Oracle ErrorPLS-00233: function name used as an exception name in when clause with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00233: function name used as an exception name in when clause

Reason for the Error PLS-00233: function name used as an exception name in when clause

The WHEN clause in an exception handler contains a function call instead of an exception name. A valid exception handler consists of a WHEN clause, which must specify an exception, followed by a sequence of statements to be executed when that exception is raised.

How to fix the Error PLS-00233: function name used as an exception name in when clause ?

You can fix this error in Oracle by following the below steps

Check the spelling of the identifier in the WHEN clause, then replace the function call with an exception name.