Re: Proving PL/SQL trigger firing sequence

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 07 Jun 2003 21:12:15 +0200
Message-ID: <77e4evoj8bbqavfttakm2m2b90niqfhic1@4ax.com>

On 7 Jun 2003 10:24:02 -0700, sharkmouth_at_hotmail.com (Saul Garcia) wrote:

>Hi All,
>
>Is there an open PL?SQL code which can be used to show the sequence
>of trigger firing with all possiblilites? That is for UPDATE, INSERT,
>DELETE at statement level, before and after at row level. Thanks,
>
>Saul Garcia

Just include debugging messages in the trigger. And, oh yes, the firing sequence of course is documented.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jun 07 2003 - 14:12:15 CDT