Quickly resolve Oracle Database errors with Oracle Doctor

Oracle Database Error PLS-00326

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-00326 Comments

No comments yet

Submit comments and questions for PLS-00326

No registration required

CAPTCHA Image New word