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

SQL*Loader-00250: Work data sets are not used by SQL*Loader

1 Answers  


LSX-00248: invalid duration "~S"

1 Answers  


ORA-07274: spdcr: access error, access to oracle denied.

2 Answers  


ORA-07842: sllfcl: SYS$CLOSE failure

1 Answers  


ORA-33006: (XSAGDNGL02) The relation workspace object is not related to itself.

1 Answers  






NNL-01077: Save Config on Stop string

1 Answers  


RMAN-08584: copying current controlfile

1 Answers  


ORA-14404: partitioned table contains partitions in a different tablespace

1 Answers  


PCC-01017: The SQLCA and a SQLCODE variable cannot both be used

1 Answers  


ORA-03280: invalid DATAFILE filename specified

1 Answers  


ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

1 Answers  


ORA-27067: size of I/O buffer is invalid

1 Answers  


Categories