PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin
Cause: The indicated identifier was also either: o) declared in package STANDARD, or o) a SQL builtin function, or o) a pseudo-column. This situation can result in name resolution issues since the STANDARD/builtin declaration will be chosen over the local declaration in SQL statements; however the local declaration will be chosen over the STANDARD/builtin declaration outside SQL scope. (See the documentation on PL/SQL name resolution.)
Action: Either: o) rename the given identifier, o) qualify any references to the identifier with the containing scope's name, or o) make sure the intended resolution occurs if using the identifier in SQL scope.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:45

PLW-05004：标识符字符串也在STANDARD中声明或是内置的SQL,
.原因：指示的标识符也是：o）在包STANDARD中声明，或o）SQL内置函数，或o）伪列。这种情况可能导致名称解析问题，因为STANDARD /内置声明将通过SQL语句中的本地声明进行选择; 然而，本地声明将通过SQL范围之外的STANDARD / builtin声明进行选择。（请参阅有关PL / SQL名称解析的文档。）,
.操作： o）重命名给定的标识符，o）使用包含范围的名称限定对标识符的任何引用，或o）如果在SQL范围中使用标识符，请确保进行预期的解析。,
.

aiaiDBA

13718043309

010-86462881

PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

1 个回答

相似问题