PCC-00078: FIPS warning: Invalid ANSI SQL Identifier

PCC-00078: FIPS warning: Invalid ANSI SQL Identifier
Cause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, the name given to a host variable:
o is longer than 18 characters,

o does not begin with a letter, or

o contains consecutive or trailing underscores. In the following Pro*C example, the host variable name is 19 characters long and therefore non-compliant: EXEC SQL BEGIN DECLARE SECTION; int department_location: -- not ANSI/ISO compliant EXEC SQL END DECLARE SECTION; This informational message is issued by the FIPS Flagger when FIPS=YES.

Action: No action required. However, for ANSI/ISO compliance, change the host variable name so that it is <= 18 characters long, begins with a letter, and does not contain consecutive or trailing underscores.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

PCC-00078：FIPS警告：无效的ANSI SQL标识符,
.原因：使用了ANSI / ISO SQL标准的Oracle扩展。具体来说，给主机变量赋予的名称：,
.o长于18个字符，,
.,
.o不以字母开头，或,
.,
.o包含连续或尾随的下划线。在以下Pro * C示例中，主机变量名称长度为19个字符，因此不符合规则：EXEC SQL BEGIN DECLARE SECTION; int department_location： - 不符合ANSI / ISO标准EXEC SQL END DECLARE SECTION; 当FIPS = YES时，该信息消息由FIPS Flagger发出。,
.,
.行动：无需采取行动。但是，对于符合ANSI / ISO标准，请更改主机变量名称，使其长度为<= 18个字符，以字母开头，不包含连续或尾随的下划线。,
.

aiaiDBA

13718043309

010-86462881

PCC-00078: FIPS warning: Invalid ANSI SQL Identifier

1 个回答

相似问题