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
3559 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-31045: Cannot store more than string extras outside the root XML node

1 Answers

ORA-12985: tablespace 'string' is read only, cannot drop column

1 Answers

NPL-00103: unusable ASN.1 context

1 Answers

ORA-38763: flashback not started; enabled threads have changed

1 Answers

TNS-12227: TNS:syntax error

1 Answers

ORA-06525: Length Mismatch for CHAR or RAW data

1 Answers

ORA-12634: Memory allocation failed

1 Answers

DRG-10702: cannot create or modify preference in another user's schema

1 Answers

ORA-03215: File Size specified for resize is too small

1 Answers

ORA-39026: master table is inconsistent on validation string

1 Answers

NZE-28863: SSL session not found

1 Answers

RMAN-06188: cannot use command when connected to a mounted target database

1 Answers

For more Oracle Errors Interview Questions Click Here