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
- 3096 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-00151: invalid transaction ID
ORA-12511: TNS:service handler found but it is not accepting connections
DRG-11216: length of datastore data exceeds limit
ORA-13029: Invalid SRID in the SDO_GEOMETRY object
ORA-12558: TNS:protocol adapter not loaded
TNS-01025: Security string
ORA-01470: In-list iteration does not support mixed operators
SQL-02118: Invalid row for a WHERE CURRENT OF operation
PLS-00258: constrained datatypes disallowed in CALL Specifications
ORA-13284: failure to copy geometry object for conversion in place
O2U-00200: Internal error in OTT facility O2U
NNL-00308: Server dumping its cache to the trace file
Oracle Errors 
