PLS-00405: subquery not allowed in this context
Cause: A subquery was used in an inappropriate context, such as: if (SELECT deptno FROM emp WHERE ... ) = 20 then ... Subqueries are allowed only in SQL statements.
Action: The same result can be obtained by using a temporary variable, as in: SELECT deptno INTO temp_var FROM emp WHERE ...; IF temp_var = 20 THEN ...
Custom Search

More Oracle errors
ORA-19723Cannot recreate plugged in read-only datafile string
PCC-01102Invalid label at line number in file string
SQL*Loader-00557unable to allocate memory
KUP-11019the following file is not valid for this fetch operation
IMG-00512multiple incompatible scaling parameters found
ORA-25951join index where clause cannot contain OR condition
QSM-02055mv references a packed object table or view
ORA-54605CREATE_PC: scratch-tables/views (string) exist and need to be dropped
DIA-48429Variable name [string] is an invalid identifier
ORA-31417column list contains control column string
ORA-02182savepoint name expected
ORA-44803Plan is in transition (about to be activated)
PCC-02414This attribute does not exist in the specified Object
QSM-01033query rewritten with materialized view, string
ORA-07646sszfck: $CREATE failure
O2F-00338Illegal or missing package name
ORA-13789invalid process action
NNL-00547Displays rename request statistics
ORA-32146Cannot perform operation on a null date
TNS-00300***Disabling Interchange : string

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-32701Hang detected
ORA-10877error signaled in parallel recovery slave string
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16957SQL Analyze time limit interrupt
ORA-16766Redo Apply is stopped
ORA-16664unable to receive the result from a database
RMAN-08137WARNING: archived log not deleted as it is still needed
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
ORA-00000normal, successful completion
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-47988password should contain at least one numeric and one alphabetic character
DIA-48122error with opening the ADR block file [string] [string]
ORA-16665timeout waiting for the result from a database
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-55508Invalid input to Flashback Transaction Backout
ORA-00001unique constraint (string.string) violated

Your own TOP 20 Oracle errors
PLS-00405subquery not allowed in this context