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-02848: Asynchronous I/O package is not running

1 Answers  


ORA-32131: bind data type cannot be changed

1 Answers  


ORA-29706: incorrect value string for parameter ACTIVE_INSTANCE_COUNT

1 Answers  


CLSR-00501: Error number encountered when connecting to EVM daemon

1 Answers  


ORA-24124: invalid ACTION parameter passed to DBMS_REPAIR.string procedure

1 Answers  






SQL-02106: Inconsistent cursor cache. Invalid Oracle cursor number

1 Answers  


TNS-00144: PUMP_CONNECTIONS value in INTCHG.ORA is too large.

1 Answers  


ORA-23431: wrong state: string

1 Answers  


RMAN-00700: SCRIPT requires that TARGET be specified on the command line

1 Answers  


PLS-01451: The data types of these <value expressions> must be comparable

1 Answers  


ORA-16055: FAL request rejected

2 Answers  


ORA-01677: standby file name convert parameters differ from other instance

1 Answers  


Categories