PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI

PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI
Cause: An Oracle extenstion to the ANSI/ISO SQL standard was used. Specifically, a numeric WHENEVER ... GOTO label was prefixed with a colon. For exammple the code might have looked like EXEC SQL WHENEVER SQLERROR GOTO :99; This informational message is issued by the FIPS Flagger when FIPS=YES.
Action: No action required. However, for ANSI/ISO compliance, prefix alphanumeric (but not numeric) WHENEVER ... GOTO labels with a colon.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

PCC-00077：WHENEVER语句中使用数字标签的冒号不是ANSI,
.原因：使用了ANSI / ISO SQL标准的Oracle扩展。具体来说，数字WHENEVER ... GOTO标签以冒号为前缀。对于exammple代码可能看起来像EXEC SQL WHENEVER SQLERROR GOTO：99; 当FIPS = YES时，该信息消息由FIPS Flagger发出。,
.行动：无需采取行动。但是，对于符合ANSI / ISO标准的前缀字母数字（但不是数字）WHENEVER ...带冒号的GOTO标签。,
.

aiaiDBA

13718043309

010-86462881

PCC-00077: Colon usage with numeric label in WHENEVER statement is not ANSI

1 个回答

相似问题