How to fix the Oracle error PLS-00395: wrong number of values in VALUES clause of INSERT statement?

In this post, you’ll learn more about the Oracle ErrorPLS-00395: wrong number of values in VALUES clause of INSERT statement with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error PLS-00395: wrong number of values in VALUES clause of INSERT statement

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

How to fix the Error PLS-00395: wrong number of values in VALUES clause of INSERT statement ?

You can fix this error in Oracle by following the below steps

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