PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause

PCC-02342: using WHERE CURRENT OF on cursor defined without
FOR UPDATE clause

Question Posted / guest

1 Answers
3474 Views
I also Faced
E-Mail Answers

PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause..

Answer / guest

Cause: When MODE=Oracle, 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 ?

1 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38741: Formatted blocks value string is not valid.

1 Answers

ORA-22826: cannot construct an instance of a non instantiable type

1 Answers

ORA-30190: reserved for future use

1 Answers

ORA-03125: client-server protocol violation

1 Answers

DRG-10837: section string does not exist

1 Answers

ORA-31060: Resource at path string could not be deleted

1 Answers

ORA-22332: a dependent object in schema "string" has errors. string

1 Answers

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

1 Answers

ORA-00292: parallel recovery feature not installed

1 Answers

ORA-00284: recovery session still in progress

1 Answers

RMAN-06903: backup of datafile string was cancelled

1 Answers

ORA-02176: invalid option for CREATE ROLLBACK SEGMENT

1 Answers

For more Oracle Errors Interview Questions Click Here