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.
