How to fix the Oracle error PCC-00007: Invalid WHENEVER condition at column number in line number of file string?

In this post, you’ll learn more about the Oracle ErrorPCC-00007: Invalid WHENEVER condition at column number in line number of file string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00007: Invalid WHENEVER condition at column number in line number of file string

Reason for the Error PCC-00007: Invalid WHENEVER condition at column number in line number of file string

Cause: A condition other than SQLERROR, SQLWARNING, or NOT FOUND was specified in an EXEC SQL WHENEVER statement, or one of these was used, but spelled incorrectly.

How to fix the Error PCC-00007: Invalid WHENEVER condition at column number in line number of file string ?

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

Action: Correct the spelling of the WHENEVER condition or use a host- language IF statement to test the special condition.