CODEWITHSUNDEEP
oracle9i
sunil kumar
sunil kumar

Reputation: 2303

ORA-000904:"ATTRIBUTE". Invalid identifier 00904.00000-"%s:invalid identifier"

One of our client is getting error ORA-000904:"ATTRIBUTE". Invalid identifier 00904.00000-"%s:invalid identifier" while running script for creating the trigger in Oracle SQL Developer. I searched for this in the forums......i got this happens when using 1.5.4 version of oracle with the oracle9i. If they use 1.5.3 or lower version of Oracle SQL developer then this can be resolved.

But they tried 1.5.3 also but they are still facing the issue. They are also telling that this is happening due to the SHOW ERROR command after the Trigger Definition.

Can anybody have the idea about this???please help me...Thanks in advance

Upvotes: 0

Views: 1406

Answers (1)

Justin Cave
Justin Cave

Reputation: 231711

The error indicates that the trigger is referring to an identifier called ATTRIBUTE that does not exist in the current scope. If you post the code, we can be more specific, but I would guess that the trigger is incorrectly expecting a table to have a column named ATTRIBUTE or that the code is trying to use a local variable ATTRIBUTE that has not been declared.

Upvotes: 1

Related Questions