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: Multiple triggers on the same event

Re: Multiple triggers on the same event

From: Jim Kennedy <jim>
Date: Wed, 8 Nov 2006 21:00:18 -0800
Message-ID: <Y9GdnZE7sbabKM_YnZ2dnUVZ_h-dnZ2d@comcast.com>

"Bill" <no_at_no.com> wrote in message
news:Kax4h.265$7L1.1390_at_eagle.america.net...
> Forgive the beginner question but, does Oracle allow multiple triggers
> on the same event? For example, can I create more than on before update
> trigger on the Customer table? Thanks.
>
> --
> .Bill.

Yes, but you have no guarantee on what the order of execution is. To solve that have 1 trigger that calls multiple stored procedures and call the stored procedures in the order you want them to execute. Jim Received on Wed Nov 08 2006 - 23:00:18 CST

Original text of this message

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