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..

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

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help

2 Answers  


PCB-00638: This attribute is only valid for internal or external LOB types

1 Answers  


ORA-25253: listen failed, queue string.string is not enabled for dequeue

1 Answers  


NZE-28803: I/O operation failure

1 Answers  


KUP-04059: found EOF in length portion of VARIABLE record in file string

1 Answers  






PCC-00126: Could not find or open system configuration file

1 Answers  


ORA-07580: spstp: $GETJPIW failure

1 Answers  


ORA-13612: The recommendation action string,string is not valid for task string.

1 Answers  


ORA-01533: cannot rename file 'string'; file does not belong to tablespace

1 Answers  


LFI-01005: Unable to fill buffer.

1 Answers  


PLS-00997: no cursor return types allowed in this beta version

1 Answers  


O2I-00132: Unable to close a Java file

1 Answers  


Categories