PLS-00326: IN clause must contain same number of expressions as subquery
Cause: The number of expressions in an IN clause did not equal the number of expressions in a corresponding subquery select list. For example, the following statement is invalid because the IN clause contains two expressions, but the subquery select list contains just one: ... WHERE (ename, sal) IN (SELECT sal FROM emp);
Action: Check the number of expressions in each set, then revise the statement to make the numbers equal.
PLS-00327
Custom Search


More Oracle errors
NNL-00898Responses sent: number
TNS-00077the argument field
RMAN-05510Duplicate finished
OCI-31044Top-level prefix length string exceeds maximum string
OCI-31065Cannot modify read-only property [string]
ORA-33468(ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
NNL-00993Auto-refresh failure retry expiration: string
ORA-38430Operation "string" not supported in the current release.
NZE-29223Cannot create certificate chain.
ORA-29807specified operator does not exist
DRG-10017you must be string to do this: string
ORA-33273(XSCHKRLS01) Analytic workspace string has open cursors and cannot be detached.
TNS-12200TNS:could not allocate memory
ORA-36837(XSLMGEN07) Object owner string is different than string
ORA-30183invalid field width specifier
ORA-37007(AWLISTALL05) number writer
NZE-29107Cannot create PKCS #12 wallet.
ORA-04002INCREMENT must be a non-zero integer
EXP-00023must be a DBA to do Full Database or Tablespace export
ORA-10563Test recovery had to corrupt data block (file# string, block# string) in order to proceed




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-00326IN clause must contain same number of expressions as subquery