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-25425: connection lost during rollback

1 Answers  


O2U-00209: Attribute or function name to be translated was not found

1 Answers  


SQL*Loader-00413: NULLIF or DEFAULTIF clause specified for filler field string in table string.

1 Answers  


ORA-09923: Can't spawn process - user log directory not created properly

1 Answers  


RMAN-08543: channel string: specifying archivelog(s) for proxy backup

1 Answers  


NCR-04012: NCRR: Invalid address descriptor

1 Answers  


ORA-25464: ROWID not specified for table alias: string

1 Answers  


SQL*Loader-00402: Unable to determine length of column string from specification

1 Answers  


ORA-16950: Remote mapped cursors are not supported by this feature.

1 Answers  


DRG-12016: The target document for this operation has moved - continue?

1 Answers  


ORA-03215: File Size specified for resize is too small

1 Answers  


ORA-16709: standby archived log location settings in conflict with flash recovery area

1 Answers  


Categories