PCC-00077: Colon usage with numeric label in WHENEVER
statement is not ANSI
- 1 Answers
- 2108 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 |
ORA-06026: NETASY: port close failure
ORA-39081: failed to unsubscribe agent string from queue "string"
QSM-02081: mv log does not have all necessary columns
ORA-12329: database string is closed; no operations are permitted
ORA-01109: database not open
ORA-27049: unable to seek to and read the last block
ORA-32103: error from OCI call
NNL-00930: Requests refused, unknown data type: number
ORA-01697: controlfile is for a clone database
ORA-23412: master table's primary key columns have changed
ORA-06580: Hash Join ran out of memory while keeping large rows in memory
RMAN-08500: channel string: sid=string devtype=string
Oracle Errors 
