PLS-00455: cursor 'string' cannot be used in dynamic SQL OPEN statement

PLS-00455: cursor 'string' cannot be used in dynamic SQL OPEN statement
Cause: dynamicly OPEN a REF CURSOR that has RETURN type. However, only REF CURSOR without RETURN type can be OPEN'ed by an embebded dynamic OPEN statement.
Action: define a REF CURSOR without return type, and use it in the statement.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00455：光标“ 串 ”不能在动态SQL OPEN语句中使用,
.原因：动态打开具有RETURN类型的REF CURSOR。但是，只有没有RETURN类型的REF CURSOR才能被一个动态OPEN语句打开。,
.操作：定义一个REF CURSOR而不返回类型，并在语句中使用它。,
.

aiaiDBA

13718043309

010-86462881

PLS-00455: cursor 'string' cannot be used in dynamic SQL OPEN statement

1 个回答

相似问题