Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple triggers on the same event
"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