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
- 3006 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-03235: max # extents (string) reached in table string.string subpartition string
NNO-00635: warning: ignoring duplicate forwarder "string"
ORA-02304: invalid object identifier literal
ORA-19500: device block size string is invalid
IMP-00092: Java object "string"."string" already exists, cannot be created
NNL-00856: Average rename processing time: string
ORA-02831: Segment deallocation failed - empty segment list
PLS-00710: PRAGMA AUTONOMOUS_TRANSACTION cannot be declared here
ORA-32619: incorrect use of MODEL ITERATION_NUMBER
PROC-00016: Cannot retrieve any more subkeys for the given keyhandle
ORA-32813: propagation schedule string already exists
NNL-00015: type "string" has "string" syntax, which has no textual representation
Oracle Errors 
