PCC-00102: FOR UPDATE is an Oracle extension
Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the FOR UPDATE OF clause was used in a cursor declaration. For example, the offending code might look like: EXEC SQL DECLARE emp_cursor CURSOR FOR SELECT ENAME, SAL FROM EMP WHERE DEPTNO = :dept_number FOR UPDATE OF SAL; This informational message is issued by the FIPS Flagger when FIPS=YES.
Action: No action required. However, for ANSI/ISO compliance, do not use the FOR UPDATE OF clause.
PCC-00103
Custom Search


More Oracle errors
OCI-19202Error occurred in XML processingstring
ORA-19686SPFILE not restored due to string
ORA-39700database must be opened with UPGRADE option
ORA-25508database is not mounted
PGU-00327command not available in this mode
NNL-00208Cancelled reload check
ORA-08464input raw decimal data contains more than 42 digits
ORA-00840PGA_AGGREGATE_TARGET cannot be modified to the specified value
RMAN-06429string database is not compatible with this version of RMAN
ORA-38741Formatted blocks value string is not valid.
OCI-31015Attempted to insert entry without name
ORA-13825missing SQL statement text for create SQL profile
NNL-00553Displays forwarding statistics
ORA-23514invalid or incorrect number of arguments
RMAN-03039Spooling for log turned off
ORA-12715invalid character set specified
ORA-36188(XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values
ORA-53038The data type name for the specified tag cannot be found.
ORA-33074(XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
LSX-00169circular group reference is disallowed outside <redefine>




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-00102FOR UPDATE is an Oracle extension