Interested to Buy Any Domain ? << Click Here >> for more details...
PCC-00079: ANSI requires colon on label in WHENEVER statement
- 1 Answers
- 2831 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-24067: exceeded maximum number of subscribers for queue string
ORA-12600: TNS: string open failed
ORA-06518: PL/SQL: Probe version string incompatible with version string
ORA-15010: name is already used by an existing ASM disk
RMAN-05013: auxiliary control filename string conflicts with a file used by the target database
PLS-00424: RPC defaults cannot include Package State
ORA-06413: Connection not open.
ORA-12345: user string lacks CREATE SESSION privilege in database link (linkname string)
LFI-00117: Unable to rename file.
ORA-04052: error occurred when looking up remote object stringstringstringstringstring
SQL*Loader-00305: More than one end of file character encountered
NID-00333: Cannot read the header of the following datafiles:
Oracle Errors 
