In this post, you’ll learn more about the Oracle ErrorORA-06567: invalid number of values specified with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-06567: invalid number of values specified
Reason for the Error ORA-06567: invalid number of values specified
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.
How to fix the Error ORA-06567: invalid number of values specified ?
You can fix this error in Oracle by following the below steps
Make sure that the same number of values have been bound for all of the bind variables.