ORA-06567: invalid number of values specified

ORA-06567: invalid number of values specified
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-06567：指定的值的数目无效,
.原因：在对DBMS_SQL包中的过程BIND_VARIABLE的调用中指定了无效的要绑定的值数。为了在给定的游标中执行给定的解析语句，必须为所有绑定变量绑定相同数量的值，因此当调用EXECUTE时，对BIND_VARIABLE的最新调用必须已指定相同数量的值为所有绑定变量。,
.操作：确保已为所有绑定变量绑定了相同数量的值。,
.

aiaiDBA

13718043309

010-86462881

ORA-06567: invalid number of values specified

1 个回答

相似问题