PLS-00406

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

Causa: 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:

Acción: Change one of the lists so that they contain the same number of items.