Re: Trigger Error ORA-04090

> 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
> >

Hy

Give a look to the 'compatible' instance parameter, in order to use two triggers firing on the same table for the same event it should be set to 'native' or at least '7.3'. You can do it editing the initSID.ora file.

Hope this help

Ciao Gennaro Received on Wed Aug 25 1999 - 10:04:34 CDT