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

In this post, you’ll learn more about the Oracle ErrorPCC-00008: Invalid WHENEVER action 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-00008: Invalid WHENEVER action at column number in line number of file string

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

Cause: At lease one of the following:

o An action other than CONTINUE, DO, GOTO, or STOP was specified in an EXEC SQL WHENEVER statement.

o One of the specified actions was spelled incorrectly.

o The host language does not allow the action (STOP is illegal in Pro*Pascal programs).

o A GOTO label is invalid.

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

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

Action: Check that the host language allows the specified WHENEVER action. If necessary, correct the spelling of the WHENEVER action or correct the GOTO label.