Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger Error ORA-04090
In 7.3, you cannot have two triggers on a table for the same event.
In your example, you have 2 triggers for After Insert on EMP.
A work around is to include the first trigger in the second or, if possible, to trigger one before and the other after Insert (another worj around is to upgrade in v8).
Anonymous a écrit dans le message <37c3c138_2_at_anonymous.newsfeeds.com>...
>
>I'm using Oracle 7.3.3.
>I have 2 different triggers :
>
> (1) the first one : After Insert on EMP
> (2) the second one : After Insert/Update on EMP
>
>I compile the trigger (1) and (2) and I don't see any error.
>
>And then, I make the same thing on a another instance on Oracle 7.3.4,
>the error "ORA-04090 specifies same table, event and trigger time ..."
>appear.
>
>Does anyone know this problem?
>Do I Have anything to do in init.ora to make this work ?
>
>Help please
>
>Thank very much
>
>
>San LUC
>san_at_a2c.fr
>
>
>
>
> --------== Posted Anonymously via Newsfeeds.Com ==-------
> Featuring the worlds only Anonymous Usenet Server
> -----------== http://www.newsfeeds.com ==----------
Received on Wed Aug 25 1999 - 05:20:59 CDT