Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00406: length of SELECT list in subquery must match
number of assignment targets
- 1 Answers
- 3027 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-24351: invalid date passed into OCI call
ORA-07643: smsalo: SMSVAR is invalid
ORA-16411: ONDEMAND archival requires active managed recovery operation
ORA-25224: sender name must be specified for enqueue into secure queues
TNS-03507: Failure looking for ADDRESS keyword
IMP-00081: attempt to free unallocated memory
ORA-29539: Java system classes already installed
ORA-32730: Command cannot be executed on remote instance
PLS-01423: Subquery on right-hand-side in set clause
NNL-00008: request not understood by server
ORA-32033: unsupported column aliasing
SQL-02140: An unnamed connection already exists
Oracle Errors 
