PCC-00079: ANSI requires colon on label in WHENEVER statement
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.
PCC-00080
Custom Search


More Oracle errors
ORA-06253NETNTT: cannot read arguments from address file
PLS-00250Incorrect Usage of string in parameters clause.
ORA-29931specified association does not exist
ORA-01251Unknown File Header Version read for file number string
ORA-28009connection as SYS should be as SYSDBA or SYSOPER
ORA-09771osnmwrtbrkmsg: bad return code from msg_send.
DRG-12431configuration section string not found
ORA-32630multiple assignment in automatic order MODEL
NNL-00533ping [<server_list>] : ping one or more Names servers
ORA-31433subscriber view does not exist
SQL-02124NULL value returned by EXEC TOOLS statement
ORA-01313LogMiner dictionary column type different from specified type
PCC-02011found identifier greater than 128 characters (truncated)
NNL-00931Requests refused, no cached meta-data: number
ORA-13438GeoRaster metadata pyramid type error
ORA-32581missing or invalid password
IMG-00554extra value in rotate operation
NNL-00559Shows, sets, or cancels the time for the next cache dump to the trace file
ORA-24908invalid recipient presentation attribute
ORA-26717SCN limit reached




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




Your own TOP 20 Oracle errors
PCC-00079ANSI requires colon on label in WHENEVER statement