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

Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid trigger

Re: Invalid trigger

From: Thomas Olszewicki <ThomasO_at_noSpm.cpas.com>
Date: Wed, 13 Jun 2001 02:11:19 GMT
Message-ID: <bZzV6.62915$W02.813583@news1.rdc2.on.home.com>

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;



END;

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

Original text of this message

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