PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI
Cause: An Oracle extenstion to the ANSI or 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.
Action: No action required. However, for ANSI or ISO compliance, prefix alphanumeric (but not numeric) WHENEVER ... GOTO labels with a colon.
Cause: An Oracle extenstion to the ANSI or 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.
Action: No action required. However, for ANSI or ISO compliance, prefix alphanumeric (but not numeric) WHENEVER ... GOTO labels with a colon.
No comments:
Post a Comment