Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04098: trigger is invalid and failed re-validation
ORA-04098: trigger is invalid and failed re-validation [message #40890] Sun, 10 November 2002 18:00 Go to next message
Chris Bartlett
Messages: 1
Registered: November 2002
Junior Member
Hi,

I am having problems with a trigger I have created - it compiles but when it runs it is giving me the error 'ORA-04098: trigger is invalid and failed re-validation'. Below is the trigger:

CREATE OR REPLACE TRIGGER st_sub_vicone_cycle_map
BEFORE INSERT OR UPDATE ON v_sub
FOR EACH ROW
BEGIN
IF (:OLD.mrkt_typ != :NEW.mrkt_typ AND :NEW.mrkt_typ = 2000040) OR
(:OLD.mrkt_typ = :NEW.mrkt_typ AND :OLD.mrkt_typ = 2000040) AND
:NEW.inv_day != 0
THEN
:NEW.inv_day := 0;
END IF;

END st_sub_vicone_cycle_map;

Can you please explain how ti fix this error?

Report message to a moderator

Re: ORA-04098: trigger is invalid and failed re-validation [message #40892 is a reply to message #40890] Sun, 10 November 2002 20:31 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Compile the trigger in SQL*Plus and then type 'show errors' to see the specific compile error. Alternatively, query the user_errors view to see the existing errors.

Report message to a moderator

Re: ORA-04098: trigger is invalid and failed re-validation [message #40896 is a reply to message #40890] Mon, 11 November 2002 04:20 Go to previous message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hai,

I think there is no error in ur trigger, it may be

ur database error.

With luv,
Balamurugan.R

Report message to a moderator

Previous Topic: Anonymous block not getting compiled
Next Topic: Why is used ..................
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 12 15:25:39 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.