Re: Proving PL/SQL trigger firing sequence

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 7 Jun 2003 16:12:49 -0700
Message-ID: <92eeeff0.0306071512.51c5f7a6@posting.google.com>

sharkmouth_at_hotmail.com (Saul Garcia) wrote in message news:<8742cd9.0306070924.53444312_at_posting.google.com>...
> 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

It's called debugging with dbms_output package. Goto http://tahiti.oracle.com and search for dbms_output.

Regards
/Rauf Sarwar Received on Sat Jun 07 2003 - 18:12:49 CDT