ORA-00947: not enough values
Oracle PL/SQL error message: ORA-00947: not enough values.
Cause:
An INSERT statement with not enough values.
Solution:
Check and change your INSERT statement to avoid the duplicate values.
Example:
INSERT INTO employees(id, name, dept_id, salary)
VALUES ('Anne', 20, 250);
SQL Error: ORA-00947: not enough values
Correct insert:
INSERT INTO employees(id, name, dept_id, salary)
VALUES (1, ‘Anne’, 20, 250);