PCB-00555: Using WHERE CURRENT OF on cursor defined without
FOR UPDATE clause



PCB-00555: Using WHERE CURRENT OF on cursor defined without FOR UPDATE clause..

Answer / guest

Cause: if mode=ORACLE, then a cursor defined with a WHERE
CURRENT OF clause must also have a FOR UPDATE clause.

Action: Rewrite the cursor definition.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24172: rule set string.string has errors

1 Answers  


ORA-13627: Setting of parameter string is disallowed until the task is reset.

1 Answers  


ORA-12899: value too large for column string (actual: string, maximum: string)

1 Answers  


RMAN-12014: multiple records for default channel configuration for string found in catalog

1 Answers  


ORA-26002: Table string has index defined upon it.

1 Answers  






NID-00122: Database should have no offline immediate datafiles

1 Answers  


TNS-01158: Internal connection limit reached, preventing dispatcher from connecting

1 Answers  


ORA-25206: enqueue failed, enqueue to exception queue string.string not permitted

1 Answers  


PLW-07203: parameter 'string' may benefit from use of the NOCOPY compiler hint

1 Answers  


ORA-37113: OLAP API initialization error: (string)

1 Answers  


ORA-22280: no more buffers available for operation

1 Answers  


ORA-19646: cannot change size of datafile string from string to string

1 Answers  


Categories