Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PCC-00102: FOR UPDATE is an Oracle extension



PCC-00102: FOR UPDATE is an Oracle extension..

Answer / guest

Cause: An Oracle extension to the ANSI/ISO SQL standard was
used. Specifically, the FOR UPDATE OF clause was used in a
cursor declaration. For example, the offending code might
look like: EXEC SQL DECLARE emp_cursor CURSOR FOR SELECT
ENAME, SAL FROM EMP WHERE DEPTNO = :dept_number FOR UPDATE
OF SAL; This informational message is issued by the FIPS
Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO
compliance, do not use the FOR UPDATE OF clause.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36272: (XSCGMDLAGG04) 'workspace object' is not a valid operator for the AGGREGATION function.

1 Answers  


ORA-13432: GeoRaster metadata blankCellValue error

1 Answers  


ORA-28561: unable to set date format on non-Oracle system

1 Answers  


ORA-31004: Length string of the BLOB in XDB$H_INDEX is below the minimum string

1 Answers  


ORA-01355: logminer tablespace change in progress

1 Answers  






KUP-03012: OCI error getting database column precision.

1 Answers  


QSM-02176: MV with UNION ALL in a view is too complex

1 Answers  


KUP-04037: terminator not found

1 Answers  


ORA-32623: incorrect use of MODEL PRESENT* functions

1 Answers  


TNS-00534: Failed to grant connection ownership to child

2 Answers  


NNO-00254: warning: parameter string value must be between number and number, set to number seconds

1 Answers  


DRG-11218: malformed mail line, line string

1 Answers  






Categories