PLS-00324: cursor attribute may not be applied to non-cursor 'string'

PLS-00324: cursor attribute may not be applied to non-cursor 'string'
Cause: This error occurs when a cursor-attribute ("%FOUND", "%NOTFOUND", "%ROWS", "%IS_OPEN", etc.) appears following an identifier that is not declared as a cursor or cursor variable. It occurs, for example, if the variable name my_cur in my_cur%FOUND was not properly declared as a cursor or if the variable declaration was placed incorrectly in the block structure.
Action: Check the spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00324：游标属性可能不适用于非游标' string ',
.原因：当未声明为游标或游标变量的标识符出现cursor-attribute（“％FOUND”，“％NOTFOUND”，“％ROWS”，“％IS_OPEN”等）时出现此错误。例如，如果my_cur％FOUND中的变量名my_cur未正确声明为游标，或者变量声明在块结构中放置不正确则会发生。,
.操作：检查标识符的拼写和声明。同时确认声明在块结构中正确放置。,
.

aiaiDBA

13718043309

010-86462881

PLS-00324: cursor attribute may not be applied to non-cursor 'string'

1 个回答

相似问题