Oracle DB Error ORA-06567 invalid number of values specified

The following is the cause of this error message:

An invalid number of values to be bound was specified in a call to the procedure BIND_VARIABLE in the package DBMS_SQL. In order to execute a given parsed statement in a given cursor, the same number of values must have been bound for all bind variables, so when EXECUTE is called, the latest calls to BIND_VARIABLE must have specified the same number of values to be bound for all bind variables.

Action you can take to resolve this issue: Make sure that the same number of values have been bound for all of the bind variables.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related