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
- 2638 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-23340: incorrect resolution method string
ORA-02186: tablespace resource privilege may not appear with other privileges
ORA-24750: incorrect size of attribute
ORA-29839: failed to validate implementation type
ORA-19011: Character string buffer too small
RMAN-20241: ambiguous archived log name
NNL-00016: cannot start server, error getting program directory's name
ORA-26684: invalid value for value_type
PCC-01101: Your Pro*FORTRAN authorization is about to expire
QSM-02033: no filter conditions are present in the WHERE clause
RMAN-04024: trying to start the Oracle instance without parameter files ...
RMAN-06518: backup will be obsolete on date string
Oracle Errors 
