Interested to Buy Any Domain ? << Click Here >> for more details...
PCC-00077: Colon usage with numeric label in WHENEVER
statement is not ANSI
- 1 Answers
- 2646 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 |
QSM-01053: NORELY referential integrity constraint on table, string, in TRUSTED/STALE TOLERATED integrity mode
RMAN-06105: duplicate qualifier found in LIST command: string
NNO-00304: listen address string length string exceeds maximum of string
ORA-12444: policy already applied to table
ORA-30656: column type not supported on external organized table
ORA-30030: suppress resumable related error message
ORA-01660: tablespace 'string' is already permanent
PLS-01422: Aliases
ORA-30352: inconsistent numeric precision or string length
SQL*Loader-00551: internal error: error initializing slf
ORA-35071: (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.
ORA-31492: could not set session parameters for LogMiner session
Oracle Errors 
