PLS-00994: Cursor Variables cannot be declared as part of a package

PLS-00994: Cursor Variables cannot be declared as part of a package
Cause: An attempt was made to declare a cursor variable in a package specification, which is not allowed. Although REF CURSOR types can be defined in a PL/SQL block, subprogram, or package, cursor variables can be declared only in a block or subprogram.
Action: Move the cursor variable declaration into a PL/SQL block or subprogram.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:03

PLS-00994：游标变量不能被声明为包的一部分,
.原因：试图在包规范中声明一个游标变量，这是不允许的。虽然可以在PL / SQL块，子程序或程序包中定义REF CURSOR类型，但只能在块或子程序中声明游标变量。,
.操作：将游标变量声明移动到PL / SQL块或子程序中。,
.

aiaiDBA

13718043309

010-86462881

PLS-00994: Cursor Variables cannot be declared as part of a package

1 个回答

相似问题