Re: Oracle Triggers

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

>
>Hi,
>
>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!
>
>John

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

-- 
Sybrand Bakker
Senior Oracle DBA