PLS-00319 subquery in an IN or NOT IN clause must contain exactly one column

Translate this page

Oracle Database Error PLS-00319

PLS-00319 subquery in an IN or NOT IN clause must contain exactly one column

Cause

An invalid expression such as X IN (SELECT A,B ...) was used. When a [NOT]IN clause is used with a subquery, it does not test for set membership. The number of expressions in the [NOT]IN clause and the subquery select list must match. So, in the example above, the subquery must specify at most one column.

Action

Change the subquery to select only one column.

User Posts for PLS-00319

Be the first to post a message...

Post your own questions, answers and tips for PLS-00319

No registration required

CAPTCHA Image New word