Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-04098: trigger name is invalid and failed re-validation
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