PLS-00406: length of SELECT list in subquery must match number of assignment targets

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/