PLS-00326: IN clause must contain same number of expressions
as subquery



PLS-00326: IN clause must contain same number of expressions as subquery..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-08459: invalid format parameter length

1 Answers  


NCR-01012: NCRS: Receive message failure.

1 Answers  


ORA-02332: cannot create index on attributes of this column

1 Answers  


ORA-13866: Client identifier must be specified

1 Answers  


ORA-22951: NULL returned by ORDER method

1 Answers  






NID-00100: Cannot open datafile "string"

1 Answers  


LCD-00210: illegal assignment operator [string]

1 Answers  


ORA-16523: Operation requires the client to connect to instance "string".

1 Answers  


TNS-00094: * to status - argument is considered the remote process_name

1 Answers  


ORA-19904: test recovery not allowed for datafile string

1 Answers  


TNS-12564: TNS:connection refused

6 Answers   Oracle,


ORA-22150: variable-length array has not been initialized

1 Answers  


Categories