Oracle Error PLS-00324: cursor attribute may not be applied to non-cursor ‘string’

Oracle Error Message

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

Reason for the Error

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.

Solution

Check the spelling and declaration of the identifier. Also confirm that the declaration is placed correctly in the block structure.