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 column list of the INSERT or subquery so they are the same length. 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.
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 column list of the INSERT or subquery so they are the same length. 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.
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 column list of the INSERT or subquery so they are the same length. 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.
