PLS-00341: declaration of cursor 'string' is incomplete or malformed

PLS-00341: declaration of cursor 'string' is incomplete or malformed
Cause: A cursor declaration is improper or an identifier referenced in the cursor declaration was not properly declared. A return type that does not refer to an existing database table or a previously declared cursor or cursor variable might have been specified. For example, the following cursor declaration is illegal because c1 is not yet fully defined: CURSOR c1 RETURN c1%ROWTYPE IS SELECT ... -- illegal In this case, a return type does not have to be specified because it is implicit.
Action: Check the spelling and declaration of the cursor name and any identifiers referenced in the cursor declaration. Also confirm that the declaration is placed correctly in the block structure. If a return type was specified, make sure that it refers to an existing database table or a previously declared cursor or cursor variable.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00341：游标' string '的声明不完整或格式错误,
.原因：游标声明不正确或光标声明中引用的标识符未正确声明。不指定现有数据库表或以前声明的游标或游标变量的返回类型可能已被指定。例如，以下游标声明是非法的，因为c1尚未完全定义：CURSOR c1 RETURN c1％ROWTYPE IS SELECT ... - illegal在这种情况下，不必指定返回类型，因为它是隐式的。,
.操作：检查游标名称和游标声明中引用的任何标识符的拼写和声明。同时确认声明在块结构中正确放置。如果指定了返回类型，请确保它引用现有数据库表或之前声明的游标或游标变量。,
.

aiaiDBA

13718043309

010-86462881

PLS-00341: declaration of cursor 'string' is incomplete or malformed

1 个回答

相似问题