Re: multiple trigger for one event

Ed Prochak wrote:

> Sybrand Bakker wrote:
> > On Tue, 18 Mar 2003 09:01:37 +0100, Robert Flügge
> > <robert.fluegge_at_bim-consulting.de> wrote:
> >
> >
> >>I have a table with 2 before-insert-triggers.
> >>The second one need the result of trigger one.
> >>Can I prescribed the order for this triggers ?
> >
> >
> > NO.
> > Please refer to your documentation Oracle *doesn't* guarantee the
> > order in which triggers are executing.
> >
> > Hence merge your 2 triggers into one.
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> Would making the second one an AFTER INERT trigger solve the problem?
>
> It needs the results of the first trigger anyway.
>
> --
> Ed Prochak
> running: http://www.faqs.org/faqs/running-faq/
> family: http://web.magicinterface.com/~collins
> --
> "Two roads diverged in a wood and I
> I took the one less travelled by
> and that has made all the difference."
> robert frost

Why are you fighting putting the code into a single trigger? Is there some point in this that I am missing?

Daniel Morgan Received on Fri Mar 21 2003 - 14:22:48 CST