Re: Oracle Triggers

From: <>
Date: Wed, 09 Apr 2008 20:00:18 +0200
Message-ID: <>

On Wed, 9 Apr 2008 07:00:12 -0700 (PDT), Mtek <> wrote:

>When a trigger is fired, is there anywhere in the data dictionary
>where it would show 'what' fired the trigger? We're looking to catch
>the stored procedure name & time that did the delete......
>Thank you!

There isn't.
There is though a 'Who called me' utility on which may also address triggers.
If this doesn't work, you obviously need to instrument it.

Sybrand Bakker
Senior Oracle DBA
Received on Wed Apr 09 2008 - 13:00:18 CDT

Original text of this message