Oracle Error Message
ORA-06567: invalid number of values specified
Reason for the Error
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 must have specified the same number of values to be bound for all bind variables.
Solution
Make sure that the same number of values have been bound for all of the bind variables.
