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

PCC-00039: Unable to open input file "string"

1 Answers  


ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed

1 Answers  


QSM-02077: mv log is newer than last full refresh

1 Answers  


TNS-01204: Unprivileged account (string) is in dba group (string)

1 Answers  


ORA-16046: Archive log destination failed due to failed dependent destination

1 Answers  






ORA-30489: Cannot have more than one rollup/cube expression list

1 Answers  


NMP-00002: no such SNMP variable name

1 Answers  


TNS-04235: Trace Assistant WARNING: Unknown TTC protocol

1 Answers  


CLSR-00002: Oracle error encountered while executing string

1 Answers  


ORA-23536: the object "string"."string" is not cached at the middle tier as expected.

1 Answers  


ORA-14103: LOGGING/NOLOGGING may not be combined with RECOVERABLE/UNRECOVERABLE

1 Answers  


PLS-00152: POINTER type may only reference an object type.

1 Answers  


Categories