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

Oracle Error Message

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

Reason for the Error

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’) …

Solution

Change one of the lists so that they contain the same number of items.