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



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

Answer / guest

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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01514: error in log specification: no such log

1 Answers  


ORA-22861: invalid user-defined type

1 Answers  


ORA-02253: constraint specification not allowed here

3 Answers  


ORA-30554: function-based index string.string is disabled

1 Answers  


PCC-01019: Invalid conversion buffer size

1 Answers  






PCB-00104: Unable to open input file "string"

1 Answers  


ORA-23611: tablespace "string" has more than one data file

1 Answers  


ORA-32026: %s.string has fewer columns compared to string table.

1 Answers  


NZE-29037: No certificate is present

1 Answers  


ORA-06549: PL/SQL: failed to dynamically open shared object (DLL): string

2 Answers  


ORA-16082: logical standby is not initialized correctly

1 Answers  


RMAN-06581: option string not supported

1 Answers  


Categories