PCC-00077: Colon usage with numeric label in WHENEVER
statement is not ANSI
- 1 Answers
- 2897 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 |
TNS-02503: Parameter retrieval failed
QSM-02007: multiple instances of the same table or view
ORA-21604: property [string] is not a property of transient or value instances
DRG-11877: This Cache Version Has Expired And Will Be Automatically Reloaded
ORA-02291: integrity constraint (string.string) violated - parent key not found
CLSS-00103: unable to read configuration information for node string
ORA-16725: the phase supplied to resource manager is invalid
ORA-30656: column type not supported on external organized table
ORA-12414: internal LBAC error: string Error: string
ORA-07245: sfccf: unable to lseek and write the last block.
ORA-16203: Unable to interpret skip procedure return values
LFI-00149: Error on destroying hash table in function string
Oracle Errors 
