PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column
Cause: An invalid expression such as X IN (SELECT A,B ...) was used. When a [NOT]IN clause is used with a subquery, it does not test for set membership. The number of expressions in the [NOT]IN clause and the subquery select list must match. So, in the example above, the subquery must specify at most one column.
Action: Change the subquery to select only one column.
PLS-00320
Custom Search


More Oracle errors
ORA-54604CREATE_PC: input points table should not be empty
PLS-00503RETURN <value> statement required for this return from function
ORA-32319Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
ORA-32052failed to start mapping service
RMAN-08057channel string: backup cancelled because all files were skipped
LFI-00102Unable to seek in sequentially accessed file.
ORA-09751pw_attachPorts: server call pws_attach failed.
OCI-22604TDS handle already generated
ORA-32604invalid REBUILD option
ORA-00031session marked for kill
IMP-00081attempt to free unallocated memory
CLSR-00517Failed to register a service name
ORA-24128partition name specified for a non-partitioned object
TNS-04064The number of CMCTL sessions exceeds MAX_CMCTL_SESSIONS.
RMAN-06119uncataloged datafile copy
ORA-24078cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
ORA-41604cannot revoke a privilege that was not granted
PGU-41012invalid PLSDNAME parameter
ORA-01326compatability of 9.0 or greater required to build into the logstream
PGU-41038TPNAME parameter was previously specified




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-00319subquery in an IN or NOT IN clause must contain exactly one column