ORA-00947

From Oracle FAQ
Jump to: navigation, search

ORA-00947: not enough values

What causes this error?[edit]

This can happen because in 2 scenarios:

  1. When the SQL statement requires 2 sets of values which are equal in number but the second set containing items lesser than the first one. This typically happens in the WHERE/HAVING clause.
  2. The INSERT statement not containing enough number of values. The number of values being inserted must be equal to the number of columns existing in the table (applies when columns names are not mentioned explicitly).

How to fix it[edit]

Fix your code.