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

PLS-00377: internal type PLS_INTEGER is not included in this release of PL/SQL

1 Answers  


ORA-29393: user string does not exist or is not logged on

1 Answers  


ORA-06126: NETTCP: ORASRV unable to open network connection

1 Answers  


RMAN-10034: unhandled exception during execution of job step number, error unknown

1 Answers  


ORA-01917: user or role 'string' does not exist

1 Answers  






KUP-03017: length specified for VARIABLE records must be greater than 0

1 Answers  


PLS-00256: %s is not a valid external library

1 Answers  


ORA-19710: unsupported character set string

1 Answers  


ORA-32110: Connection not specified

1 Answers  


ORA-00316: log string of thread string, type string in header is not log file

1 Answers  


ORA-40253: no target counter examples were found

1 Answers  


ORA-25209: invalid value string, EXPIRATION should be non-negative or NEVER

1 Answers  


Categories