ORA-29256: Cursor contains both regular and array defines which is illegal

ORA-29256: Cursor contains both regular and array defines which is illegal
Cause: Both define_array and define_column have been called on this cursor. This is illegal. It is not possible for a cursor to both contain regular and array defines. The semantics of this setting are nonsensical. Array defines are used to move data from select queries into PL/SQL tables and regular defines to move data from select queries into PL/SQL variables.
Action: Modify your PL/SQL program to only perform calls to one of the two functions depending on the situation at hand.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-29256：游标包含正则和数组定义，这是非法的,
.原因： define_array和define_column都已在此游标上调用。这是非法的。游标不能同时包含规则和数组定义。这个设置的语义是无意义的。数组定义用于将数据从选择查询移动到PL / SQL表和常规定义，以将数据从选择查询移动到PL / SQL变量。,
.操作：修改PL / SQL程序，仅根据当前情况执行对两个函数之一的调用。,
.

aiaiDBA

13718043309

010-86462881

ORA-29256: Cursor contains both regular and array defines which is illegal

1 个回答

相似问题