Oracle Error PLS-00395: wrong number of values in VALUES clause of INSERT statement

Oracle Error Message

PLS-00395: wrong number of values in VALUES clause of INSERT statement

Reason for the Error

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);

Solution

Change the number of items in the column list or the number of items in the VALUES list so that the numbers match.