PCB-00308: FOR clause is an Oracle extension

PCB-00308: FOR clause is an Oracle extension
Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the FOR clause was used in an table-processing SQL statement. For example, the offending code might look like: EXEC SQL FOR :LIMIT INSERT INTO EMP (EMPNO, JOB, DEPTNO) VALUES (:EMPNUM, :JOB, :DEPTNO) END-EXEC. 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 clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:48

PCB-00308：FOR子句是一个Oracle扩展,
.原因：使用了ANSI / ISO SQL标准的Oracle扩展。具体来说，FOR子句用于表处理SQL语句。例如，违规代码可能如下所示：EXEC SQL FOR：LIMIT INSERT INTO EMP（EMPNO，JOB，DEPTNO）VALUES（：EMPNUM，：JOB，：DEPTNO）END-EXEC。当FIPS = YES时，该信息消息由FIPS Flagger发出。,
.行动：无需采取行动。但是，对于符合ANSI / ISO规定，请勿使用FOR子句。,
.

aiaiDBA

13718043309

010-86462881

PCB-00308: FOR clause is an Oracle extension

1 个回答

相似问题