PCC-00110: Oracle extension to the WHENEVER statement

PCC-00110: Oracle extension to the WHENEVER statement
Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, a nonconforming keyword such as NOTFOUND, STOP, RAISE, or DO was used in the WHENEVER statement. (Note that NOT FOUND is ANSI-compliant.) For example, the offending code might look like: EXEC SQL WHENEVER SQLERROR STOP; 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 nonconforming keyword.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

PCC-00110：Oracle扩展到WHENEVER语句,
.原因：使用了ANSI / ISO SQL标准的Oracle扩展。具体来说，在WHENEVER语句中使用了不合格的关键字，如NOTFOUND，STOP，RAISE或DO。（请注意，NOT FOUND符合ANSI标准。）例如，违规代码可能如下所示：EXEC SQL WHENEVER SQLERROR STOP; 当FIPS = YES时，该信息消息由FIPS Flagger发出。,
.行动：无需采取行动。但是，对于ANSI / ISO合规性，请勿使用不合格的关键字。,
.

aiaiDBA

13718043309

010-86462881

PCC-00110: Oracle extension to the WHENEVER statement

1 个回答

相似问题