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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09215: sfqio: error detected in IOCompletionRoutine

1 Answers  


ORA-00981: cannot mix table and system auditing options

1 Answers  


ORA-16011: Archivelog Remote File Server process in Error state

1 Answers  


TNS-00127: Missing Connection Manager name in TNSNET.ORA

1 Answers  


PLS-00210: an OTHERS clause is required in this CASE statement

1 Answers  






PCC-02322: found undefined identifier

1 Answers  


ORA-06610: LU6.2 Driver: Failed during deallocation

1 Answers  


RMAN-03014: implicit resync of recovery catalog failed

1 Answers  


ORA-25326: Array string operation failed for message at index string

1 Answers  


ORA-02770: Total number of blocks is invalid

1 Answers  


ORA-01679: database must be mounted EXCLUSIVE and not open to activate

1 Answers  


DRG-50860: failed to prepare statement

1 Answers  


Categories