Re: trigger question

From: Igor Popov <ipopov_at_solect.com>
Date: Thu, 04 Jun 1998 08:56:27 -0400
Message-ID: <3576997B.D509924E@solect.com>

Martin Dick wrote:

> Igor Popov wrote in message <3575CBD6.DECC75E8_at_solect.com>...
> >I'm running oracle 7.3.4 and trying to create two identical triggers
> >with different names. Oracle returns error ORA-04090: 'tr1' specifies
> >same table, event and trigger time as 'tr2'. The same thing works
> >perfectly in 7.3.3, 7.2.X. Any ideas?
> >
>
> I'm curious as to why you would want two identical triggers with different
> names.
> I can't think of any logical reason...

Of course it doesn't make sense to do it, I just used this example to show the problem in a simpler manner. In practice it's necessary sometimes to create a few unrelated triggers with the same condition and it seems Oracle doesn't allow to do it any more. Received on Thu Jun 04 1998 - 07:56:27 CDT