PLW-05004: identifier string is also declared in STANDARD or
is a SQL builtin

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

IMG-02003: 2FF03 - incorrect color histogram feature specification

1195


When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2306


ORA-26095: unprocessed stream data exists

2790


ORA-26084: direct path context already finished

1477


ORA-26076: cannot set or reset value after direct path structure is allocated

1464






ORA-26079: file "string" is not part of table string.string

1512


IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2289


ORA-26027: unique index string.string partition string initially in unusable state

6148


ORA-26029: index string.string partition string initially in unusable state

1701


ORA-26082: load of overlapping segments on table string.string is not allowed

1366


ORA-16516: The current state is invalid for the attempted operation.

8055


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2320


if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2224


ORA-26094: stream format error: input column overflow

2242


IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1230