Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid trigger
Dave,
CREATE OR REPLACE TRIGGER ADDRESS_ID_TRIG
BEFORE INSERT
ON ADDRESS
FOR EACH ROW
BEGIN
SELECT ADDRESS_SEQ.NEXTVAL
INTO :NEW.ADDRESS_ID
FROM DUAL;
HTH
Thomas
<dave_at_lake.demon.co.uk> wrote in message
news:992386665.13133.0.nnrp-02.9e981a9c_at_news.demon.co.uk...
> Hi,
>
> I'm getting an error when trying to insert into a table
>
> ORA-04098: trigger 'DAVE.ADDRESS_ID_TRIG' is invalid and failed
> re-validation
>
> Not really sure what this means. I had no problem creating the trigger.
> The trigger is as follows:
>
> CREATE SEQUENCE ADDRESS_SEQ;
>
> CREATE OR REPLACE TRIGGER ADDRESS_ID_TRIG
> BEFORE INSERT
> ON ADDRESS
> FOR EACH ROW
> BEGIN
> SELECT ADDRESS_SEQ.NEXTVAL
> INTO :NEW.ADDRESS_ID
> FROM DUAL;
>
> I'm using Oracle8i Enterprise Edition Release 8.1.7.0.1 on Linux Redhat
> 7, kernel 2.4.2
>
> Any ideas? Many thanks in advance.
>
> Dave
Received on Tue Jun 12 2001 - 21:11:19 CDT