PLS-00319: subquery in an IN or NOT IN clause must contain
exactly one column
- 1 Answers
- 1699 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-02433: cannot disable primary key - primary key not defined for table
NNO-00604: disabling all request processing
ORA-30352: inconsistent numeric precision or string length
ORA-13345: a compound polygon geometry has fewer than five coordinates
ORA-12689: Server Authentication required, but not supported
TNS-12642: No session key
QSM-01017: aggregate argument cannot be converted to canonical form
ORA-27122: unable to protect memory
ORA-09370: Windows 3.1 Two-Task driver ORACLE task timed out
ORA-19000: missing RELATIONAL keyword
TNS-00120: Missing PUMPS in INTCHG.ORA
ORA-07589: spdde: system ID not set
Oracle Errors 
