PCC-00077: Colon usage with numeric label in WHENEVER
statement is not ANSI
- 1 Answers
- 2227 Views
- I also Faced
- E-Mail Answers
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 |
O2I-00119: Warning reported by subsystem:
DRG-13011: language column must be specified when using the multi lexer
ORA-07703: error in archive text: need '/' after device type
NNC-00415: section identifier string is invalid, must be between string and string
ORA-12019: master table is a synonym to a remote object
PCC-00100: Non integer label is not ANSI
TNS-12508: TNS:listener could not resolve the COMMAND given
ORA-29522: authorization error for referenced name string.string
PCC-00076: DISPLAY type must be SIGN LEADING SEPARATE
ORA-07473: snclrd: read error when trying to read sgadef.dbf file.
ORA-30362: dimension column cannot be a sequence
ORA-36884: (XSSRF03) The value of the first parameter of the AW single row function is incorrect.
Oracle Errors 
