ORA-06569: Collection bound by bind_array contains no elements

ORA-06569: Collection bound by bind_array contains no elements
Cause: A collection with zero elements was bound to a bind variable in a call to procedure BIND_ARRAY in the package DBMS_SQL. In order to execute a bind of a collection, the collection must contain at least one element. If no elements are present then at execute time there will be no value for this bind and the statement is meaningless.
Action: Fill the collection with the elements you want to bind and try the bind call again.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:38

ORA-06569：由bind_array绑定的集合不包含元素,
.原因：在对包DBMS_SQL中的过程BIND_ARRAY的调用中，具有零个元素的集合被绑定到绑定变量。为了执行集合的绑定，集合必须至少包含一个元素。如果没有元素，那么在执行时，这个绑定将没有值，并且语句是无意义的。,
.操作：使用要绑定的元素填充集合，然后再次尝试绑定调用。,
.

aiaiDBA

13718043309

010-86462881

ORA-06569: Collection bound by bind_array contains no elements

1 个回答

相似问题