Quickly resolve Oracle Database errors with Oracle Doctor

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.

PLS-00319 Comments

No comments yet

Submit comments and questions for PLS-00319

No registration required

CAPTCHA Image New word