PLS-00395: wrong number of values in VALUES clause of INSERT statement
Cause: The number of columns in an INSERT statement does not match the number of values in the VALUES clause. For example, the following statement is faulty because no column is specified for the value 20: INSERT INTO emp (empno, ename) VALUES (7788, SCOTT , 20);
Action: Change the number of items in the column list or the number of items in the VALUES list so that the numbers match.
Cause: The number of columns in an INSERT statement does not match the number of values in the VALUES clause. For example, the following statement is faulty because no column is specified for the value 20: INSERT INTO emp (empno, ename) VALUES (7788, SCOTT , 20);
Action: Change the number of items in the column list or the number of items in the VALUES list so that the numbers match.
No comments:
Post a Comment