dbms_output.put_line in a database trigger

From: Joe Bo <parker_at_indiamail.com>
Date: 23 Aug 2001 10:15:03 -0700
Message-ID: <a8cf5098.0108230915.1efb2c8c@posting.google.com>

I have a database trigger on table a , which inserts records into table b, which in turn has a trigger which inserts into table c, which once again has a trigger which inserts into table d.

Now I want to know if I can include calls to dbms_output.put_line, in all the 3 triggers , and know where the operation is at a partiticular given point. i.e. if the process is in trigger on table a then i will display 'CURRENTLY EXECUTING TRIGGER ON TABLE A', and then the same with the other 2 triggers.

Is this possible . Received on Thu Aug 23 2001 - 12:15:03 CDT