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-16628: The broker protection mode is inconsistent with the database setting.

1 Answers  


ORA-31530: could not find published column string for CDC subscriber view string.string

1 Answers  


ORA-19693: backup piece string already included

1 Answers  


ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

2 Answers   HCL,


ORA-16573: attempt to change configuration file for an enabled broker configuration

1 Answers  


PLS-00631: PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argument

1 Answers  


NCR-01004: NCRS: Write error.

1 Answers  


ORA-13786: missing SQL text of statement object "string" for tuning task "string"

1 Answers  


KUP-04059: found EOF in length portion of VARIABLE record in file string

1 Answers  


DRG-51025: an invalid character was passed to the stemmer

1 Answers  


QSM-01081: no primary key or row id found for table, string, in MV, string

1 Answers  


ORA-24028: cannot create a reciever non-repudiable single consumer queue

1 Answers  


Categories