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-30362: dimension column cannot be a sequence

1 Answers  


ORA-16578: failed to read Data Guard configuration file

1 Answers  


ORA-26023: index string.string partition string was made unusable due to:

1 Answers  


ORA-29664: Unable to generate the helper class for the defined type

1 Answers  


RMAN-12010: automatic channel allocation initialization failed

1 Answers  


ORA-24280: invalid input value for parameter string

1 Answers  


ORA-23497: repgroup name cannot be null

1 Answers  


ORA-27126: unable to lock shared memory segment in core

1 Answers  


ORA-31151: Cyclic definition encountered for string: "string"

1 Answers   FBCH,


ORA-09293: sksasmo: unable to send message to console

1 Answers  


PCC-00019: Unable to obtain bind variables at line number in file string

1 Answers  


NZE-28769: Specified method does not exist.

1 Answers  


Categories