PLS-00406: length of SELECT list in subquery must match
number of assignment targets
- 1 Answers
- 2571 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-08186: invalid timestamp specified
ORA-25449: invalid variable name: string
RMAN-10034: unhandled exception during execution of job step number, error unknown
ORA-23356: masterdef recognizes a master which does not recognize the masterdef
ORA-25508: database is not mounted
ORA-24378: user callbacks not allowed for this call
SQL*Loader-00200: FORMAT clause should not be present - flat data files only
ORA-36978: (XSRELGID01) workspace object must be a self-relation.
ORA-13429: invalid xCoefficients or yCoefficients parameter(s)
NZE-28794: data type attribute did not initialize
NNL-01056: Requests forwarded: number
ORA-12072: updatable materialized view log data for "string"."string" cannot be created
Oracle Errors 
