PLS-00120: inappropriate argument in OPEN statement
Cause: The asterisk (*) option was used in the argument list of a SQL group function other than COUNT. For example, the code might look like SELECT SUM(*) INTO emp_count FROM emp; -- should be COUNT(*) Only COUNT permits the use of the asterisk option, which returns the number of rows in a table.
Action: Remove the asterisk option from the argument list and replace it with an expression that refers to one or more database columns.
PLS-00122
Custom Search


More Oracle errors
NID-00306Datafile string - no revert needed
PCB-00210DISPLAY-1 only allowed with PIC G and PIC N variables "string"
NNL-00228Request-processing delay is now string
ORA-26037must specify partition name(s) for system partitioned table string
ORA-27014skgfqpini: translation error while expanding SS_UDMPDIR
RMAN-12016using channel string
DRG-12226a field section named string already exists in this section group
CLSS-00200local node string not listed in configuration
RMAN-12011multiple records for default device type found in catalog
ORA-31014Attempted to delete the root container
ORA-24770cannot forget a prepared transaction
RMAN-00554initialization of internal recovery manager package failed
ORA-07840sllfop: LIB$GET_VM failure
ORA-27018BLKSIZE is not a multiple of the minimum physical block size
ORA-27371jobs of type EXECUTABLE are not supported on this platform
LFI-00152Read operation (byte mode) failed.
OCI-22276invalid locator for LOB buffering
ORA-22803object type contains zero attributes
KUP-04028conversion of character length to a number failed
ORA-33452(ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace




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
PLS-00120inappropriate argument in OPEN statement