Re: multiple trigger for one event

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 18 Mar 2003 10:33:05 +0100
Message-ID: <rspd7vo4prgoq5drbqrug1fu30l1hfcv1a@4ax.com>

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 Received on Tue Mar 18 2003 - 03:33:05 CST