In this post, you’ll learn more about the Oracle ErrorPLW-05004: identifier string is also declared in STANDARD or is a SQL builtin with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin
Reason for the Error PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin
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.)
How to fix the Error PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin ?
You can fix this error in Oracle by following the below steps
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.