How to fix the Oracle error PLS-00406: length of SELECT list in subquery must match number of assignment targets?

In this post, you’ll learn more about the Oracle ErrorPLS-00406: length of SELECT list in subquery must match number of assignment targets with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error PLS-00406: length of SELECT list in subquery must match number of assignment targets ?

You can fix this error in Oracle by following the below steps

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