How to fix the Oracle error PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI?

In this post, you’ll learn more about the Oracle ErrorPCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI

Reason for the Error PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI

Cause: An Oracle extenstion to the ANSI/ISO SQL standard was used. Specifically, a numeric WHENEVER … GOTO label was prefixed with a colon. For exammple the code might have looked like EXEC SQL WHENEVER SQLERROR GOTO :99; This informational message is issued by the FIPS Flagger when FIPS=YES.

How to fix the Error PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI ?

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

Action: No action required. However, for ANSI/ISO compliance, prefix alphanumeric (but not numeric) WHENEVER … GOTO labels with a colon.