Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00000: Not An Error

1 Answers  


ORA-02262: ORA-string occurs while type-checking column default value expression

1 Answers  


ORA-16518: unable to allocate virtual instance id

1 Answers  


TNS-01408: Instance "string", status string, has string handler(s) for this service...

1 Answers  


ORA-31401: change source string is not an existing change source

1 Answers  






ORA-09803: Allocation of string buffer failed.

1 Answers  


ORA-13331: invalid LRS segment

1 Answers  


ORA-27546: Oracle compiled against IPC interface version string.string found version string.string

1 Answers  


ORA-10562: Error occurred while applying redo to data block (file# string, block# string)

1 Answers  


ORA-09744: smsget: mmap returned an error.

1 Answers  


ORA-25303: Buffered operation allowed only on the owner instance

1 Answers  


PCC-02451: Value of offset cannot be negative in ABSOLUTE orientation mode

1 Answers  






Categories