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

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

INSERT INTO emp (ename, empno) 

SELECT col1, col2, col3 

FROM ...

Action: 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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/