Re: Trigger Problem !

Peter Cheung wrote:

> I created a table with the following trigger in Oracle 8.0.3 on a NT
> machine:
>
> CREATE OR REPLACE TRIGGER "BEF_ROW_UPDT_TS" BEFORE INSERT OR UPDATE OF
> "DESCRIPTION", "ID" ON "TTABLE" REFERENCING OLD AS OLD NEW AS NEW FOR
> EACH ROW BEGIN :new.LASTUPDTDATE:=SYSDATE;:new.REFCOUNTER:=
> :old.REFCOUNTER+1;
> END
>
> ;
>
> However, when I tried to update the "DESCRIPTION" of "TTABLE", I
> received the following error message:
>
> SQLSTATE: S1000
> Native Error Code: 4098
> Driver Message: ORA-04098 'BEF_ROW_UPDT_TS' is invalid and failed
> re-validation.
>
> I could not figure out what went wrong ? Please help. Thx.

  Hi
Try
select trigger_name from user_Triggers where status = 'Invalid' (or like)

If the trigger specified is invalid re-compile again and execute..

Hope this will work

Good Luck

Pradhan Received on Tue Jun 02 1998 - 00:00:00 CEST