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

Translate this page

Oracle Database Error PLS-00324

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.

User Posts for PLS-00324

Be the first to post a message...

Post your own questions, answers and tips for PLS-00324

No registration required

CAPTCHA Image New word