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
- 2821 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-24063: cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
ORA-37111: Unable to load the OLAP API sharable library: (string)
ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string)
ORA-27069: attempt to do I/O beyond the range of the file
LSX-00111: type "~S" contains invalid facets
NZE-29035: Pseudo Random Number Generator is needed
ORA-07605: szprv: $ASCTOID failure
PCB-00577: Use of ARRAYLEN with host tables in SQL statements is ignored
ORA-01202: wrong incarnation of this file - wrong creation time
LFI-00125: Random access only allowed on fixed length record files.
PCB-00627: Host variable is not of character type
ORA-16175: cannot shut down database when media recovery is active
Oracle Errors 
