Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-04098: trigger name is invalid and failed re-validation

Re: ORA-04098: trigger name is invalid and failed re-validation

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 2000/07/11
Message-ID: <49hMdLAU9sa5Ewpl@ahardy.demon.co.uk>#1/1

In article <39618b3e.88772327_at_news.dia.dk>, Claus Nielsen <claus_at_jsedb. dk> writes
>I am unable to use any kind of trigger I make. Not that I have ever
>succeded at getting any trigger to work, as I am new at this. But I
>have created the following trigger - just as an example:
>
>CREATE TRIGGER TRIGGER1
>BEFORE INSERT
>ON TABLE1
>FOR EACH ROW
>BEGIN
> NEW.ID := 3;
This should be :NEW.ID := 3;

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================
Received on Tue Jul 11 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US