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

RMAN-06017: initialization of parser failed

1 Answers  


DRG-11869: Premature End Of File Detected

1 Answers  


ORA-25157: Specified block size string is not valid

1 Answers  


ORA-01136: specified size of file string (string blocks) is less than original size of string blocks

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  


ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

1 Answers  


ORA-36988: (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.

1 Answers  


ORA-22312: must specify either CASCADE or INVALIDATE option

1 Answers  


ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

1 Answers  


PLS-01912: : instance must of be of type 'string'

1 Answers  


ORA-07615: $CHANGE_CLASS failed in retrieving the specified file label

1 Answers  


ORA-02327: cannot create index on expression with datatype string

1 Answers  


Categories