ORA-06567: invalid number of values specified



ORA-06567: invalid number of values specified..

Answer / guest

Cause: 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.

Action: Make sure that the same number of values have been
bound for all of the bind variables.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30487: ORDER BY not allowed here

1 Answers  


LPX-00004: internal error "~s"

1 Answers  


ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  


NID-00350: string (number) string

1 Answers  


ORA-07240: slemrd: seek error.

1 Answers  






PLS-01419: Subquery must have either '*' or exactly one column in its select list

1 Answers  


ORA-19735: wrong creation SCN - control file expects initial plugged-in datafile

1 Answers  


TNS-00520: Syntax error

1 Answers  


AMD-00138: level names parameter not null or defaulted

1 Answers  


ORA-16181: SGA specified for Logical Standby is too large

1 Answers  


SQL*Loader-00965: Error number disabling constraint string on table string

1 Answers  


ORA-23540: Redefinition not defined or initiated

1 Answers  


Categories