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

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.

Share:

Leave a Reply

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...