PLS-00404: cursor 'string' must be declared with FOR UPDATE to use wi

PLS-00404: cursor 'string' must be declared with FOR UPDATE
to use with CURRENT OF

Question Posted / guest

1 Answers
4903 Views
I also Faced
E-Mail Answers

PLS-00404: cursor 'string' must be declared with FOR UPDATE to use with CURRENT OF..

Answer / guest

Cause: The use of the CURRENT OF cursor_name clause is legal
only if cursor_name was declared with a FOR UPDATE clause.

Action: Add a FOR UPDATE clause to the definition of the
cursor or do not use the CURRENT OF cursor_name clause.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11129: the rule table is empty

1 Answers

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

0 Answers

PLS-00633: RETURN statement in a pipelined function cannot contain an expression

1 Answers

ORA-00271: there are no logs that need archiving

1 Answers

PLS-00339: "string" matches object-table without a REF or VALUE modifier

1 Answers

ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue

1 Answers

ORA-23337: priority or value not in priority group string

1 Answers

NZE-28766: failure to terminate use of data source