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-09761: pw_destroyPorts: server call pws_stop_instance failed.

1 Answers  


NNO-00123: node "string" has no authoritative parent, data ignored

1 Answers  


PROT-00301: Dump is not feasible when clusterware is running

1 Answers  


NZE-29039: There are no matching cipher suites.

1 Answers  


PCC-00021: Oracle Error: string

1 Answers  






ORA-00824: cannot set sga_target due to existing internal settings

1 Answers  


KUP-04020: found record longer than buffer size supported, number, in string

1 Answers  


O2I-00111: Unable to allocate memory

2 Answers  


ORA-01497: illegal option for ANALYZE CLUSTER

1 Answers  


ORA-25330: PL/SQL associative arrays may not be used with AQ array operations

1 Answers  


LPX-00103: document structure does not match DTD

1 Answers  


ORA-02434: cannot enable unique(string) - unique key not defined for table

1 Answers  


Categories