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-25139: invalid option for CREATE TEMPORARY TABLESPACE

1 Answers  


RMAN-06085: must use SET NEWNAME command to restore datafile string

1 Answers  


ORA-29968: No primary operator bindings found for ancillary binding #string

1 Answers  


DRG-12233: xml sections cannot co-exist with other section types

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


DRG-11819: Bad Request

1 Answers  


ORA-16767: Logical apply service unexpectedly online

1 Answers  


ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package

1 Answers  


ORA-24006: cannot create QUEUE, string already exists

1 Answers  


ORA-33443: (ESDREAD14) Discarding compiled code for workspace object because analytic workspace string is not attached.

1 Answers  


ORA-12546: TNS:permission denied

1 Answers  


RMAN-06436: enter DROP CATALOG command again to confirm catalog removal

1 Answers  


Categories