PLS-00396

Error: PLS-00396: INSERT statement's subquery yields wrong number of columns

Causa: The number of columns in an INSERT statement does not match the number of columns in a subquery select list. For example, the following statement is faulty because no corresponding column is specified for col3:

Acción: Change the number of items in the column list of the INSERT statement or the number of items in the select list so that the numbers match.