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
- 3155 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-24417: Session pool size has exceeded the maximum limit
ORA-03242: Tablespace migration retried 500 times
ORA-04009: MAXVALUE cannot be made to be less than the current value
ORA-00096: invalid value string for parameter string, must be from among string
ORA-30153: An invalid File Object is passed to the OCIFile function
DRG-50864: number assignment failed
PLS-00233: function name used as an exception name in when clause
TNS-01017: set|show current_listener [<listener_name>]: sets|shows current listener
KUP-03019: directory object not specified in LOBFILE clause for field string
NNC-00429: invalid octet string literal "string"
ORA-07400: slemtr: translated name for the message file is too long.
ORA-25470: duplicate attribute value for variable: string
Oracle Errors 
