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
- 3073 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-19670: file string already being restored
ORA-33020: (XSAGDNGL09) In AGGMAP workspace object, the MIN argument of number must be less than the MAX argument of number.
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
RMAN-01008: the bad identifier was: string
NZE-28868: Peer certificate chain check failed.
ORA-02773: Invalid maximum client wait time
ORA-19694: some changed blocks were not found in the change tracking file
IMP-00006: failed to allocate memory of size number
ORA-27023: skgfqsbi: media manager protocol error
ORA-10581: Can not modify redo log header during test recovery
NNO-00118: line string: data length string exceeds maximum of string, data ignored
DRG-10583: TRUNCATE INDEX failed: string
Oracle Errors 
