Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PLS-00373: EXIT label 'string' must label a LOOP statement

1 Answers  


PCC-02367: This indicator variable must be declared as type short

1 Answers  


ORA-01333: failed to establish Logminer Dictionary

1 Answers  


DRG-12512: invalid stop class string

1 Answers  


ORA-02046: distributed transaction already begun

1 Answers  






TNS-02514: Invalid packet received

1 Answers  


ORA-13403: invalid rasterDataTable specification

1 Answers  


CLSR-00521: Event string is rejected by EVM daemon

1 Answers  


RMAN-06909: WARNING: parallelism require Enterprise Edition

2 Answers  


TNS-00537: Index into protocol adapter table is out of legal range

1 Answers  


NZE-29047: Mismatch in Transport Layer Security extension

1 Answers  


ORA-14515: only one aubpartition name can be specified

1 Answers  






Categories