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-01170: file not found 'string'

1 Answers  


ORA-26712: remote object is "string"."string"\@"string"

1 Answers  


PCC-00051: Size of VARCHAR string is larger than 65533 in line number in file string

1 Answers  


ORA-00259: log string of open instance string (thread string) is the current log, cannot archive

1 Answers  


QSM-01028: materialized view, string, is currently being refreshed

1 Answers  






SQL*Loader-00608: subpartition not empty for INSERT option; table string, subpartition string

1 Answers  


IMP-00067: Could not convert to server character set's handle

1 Answers  


NZE-28824: invalid encryption/decryption/signature state passed

1 Answers  


ORA-01023: Cursor context not found (Invalid cursor number)

1 Answers  


NNL-00344: Save_config_on_stop is currently ON

1 Answers  


EXP-00068: tablespace string is offline

1 Answers  


ORA-30366: child JOIN KEY columns not in same relation as child level

1 Answers  


Categories