PLS-00406: length of SELECT list in subquery must match
number of assignment targets
- 1 Answers
- 2107 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A query select list is not the same length as the
list of targets that will receive the returned values. For
example, the following statement is faulty because the
subquery returns two values for one target: UPDATE emp SET
ename = (SELECT ename, empno FROM emp WHERE ename = 'SMITH') ...
Action: Change one of the lists so that they contain the
same number of items.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-38102: Invalid column in the INSERT WHERE Clause: string
ORA-27027: sbtremove2 returned error
ORA-02447: cannot defer a constraint that is not deferrable
ORA-39103: Timeout before worker process string finished initialization. Worker error:
ORA-02479: error while translating file name for parallel load
PLS-00405: subquery not allowed in this context
ORA-25326: Array string operation failed for message at index string
ORA-03250: Cannot mark this segment corrupt
LSX-00152: only "minOccurs", "maxOccurs", or "id" is allowed
ORA-01140: cannot end online backup - all files are offline or readonly
ORA-02367: file truncated error in string
ORA-29534: referenced object string.string could not be resolved
Oracle Errors 
