Reason:
The number of values specified in a statement intended to update columns in a table does not match the number of columns specified in that statement. When using INSERT with the SELECT statement, the number of columns in the SELECT list must equal the number of columns in the INSERT column list or, if the INSERT column list is omitted, must equal the number of columns in the table.
When using the INSERT VALUES statement, the number of values in the value list must equal the number of columns in the table. Or, if an INSERT column list is specified, the number of columns in that list.
The SQLSTATE that equates to this SQL return code is 42802.
Action:
Correct the statement in question so that the number of values specified corresponds to the number of columns.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|