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-16805: Change of LogXptMode property violates overall protection mode.

1 Answers  


ORA-19740: text is longer than string

1 Answers  


LPX-00411: unknown function name encountered

1 Answers  


RMAN-08586: output filename=string tag=string recid=string stamp=string

1 Answers  


ORA-24905: invalid recepient protocol attribute passed into OCI call

1 Answers  






PLS-00123: program too large

1 Answers  


ORA-01139: RESETLOGS option only valid after an incomplete database recovery

1 Answers  


ORA-02735: osnfpm: cannot create shared memory segment

1 Answers  


LSX-00285: referenced key "~S" is not defined

1 Answers  


ORA-29360: retry operation. Too much concurrent activity

1 Answers  


ORA-13291: conversion error between the specified unit and standard unit

1 Answers  


PLS-00591: this feature is not supported in client-side programs

1 Answers  


Categories