Interested to Buy Any Domain ? << Click Here >> for more details...
PCC-00079: ANSI requires colon on label in WHENEVER statement
- 1 Answers
- 2758 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: An Oracle extension to the ANSI/ISO SQL standard was
used. Specifically, an alphanumeric WHENEVER ... GOTO label
was not prefixed with a colon. For example the offending
code might look like: EXEC SSQL WHENEVER NOT FOUND GOTO
no_more; 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-16164: LGWR network server host detach error
ORA-12678: Authentication disabled but required
ORA-16204: DDL successfully applied
ORA-01175: data dictionary has more than the string files allowed by the instance
TNS-02510: Invalid numeric data type
CLSS-00001: skgxn not active
NNL-00995: Unmatched responses received: number
QSM-01019: no suitable materialized view found to rewrite this query
ORA-24904: invalid callback attribute passed into OCI call
ORA-14053: illegal attempt to modify string in string statement
ORA-16775: Target standby in switchover operation has missing redo logs.
ORA-19007: Schema string does not match expected string.
Oracle Errors 
