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-28534: Heterogeneous Services preprocessing error

1 Answers  


AMD-00139: level names parameter not valid

1 Answers  


ORA-14131: enabled UNIQUE constraint exists on one of the tables

1 Answers  


ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications

1 Answers  


CLSR-00522: Resource string is not registered

1 Answers  






ORA-01070: Using an old version of Oracle for the server

1 Answers  


ORA-02096: specified initialization parameter is not modifiable with this option

1 Answers  


SQL*Loader-00114: Error in OPTIONS statement

1 Answers  


RMAN-06033: channel string not allocated

1 Answers  


RMAN-08011: including current controlfile in backupset

1 Answers  


PROT-00007: Failed to open the specified import file

1 Answers  


TNS-12585: TNS:data truncation

1 Answers  


Categories