Re: Oracle Triggers
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 09 Apr 2008 13:08:26 -0700
Message-ID: <1207771705.842856@bubbleator.drizzle.com>
>
> 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.
Date: Wed, 09 Apr 2008 13:08:26 -0700
Message-ID: <1207771705.842856@bubbleator.drizzle.com>
sybrandb_at_hccnet.nl wrote:
> 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.
OWA_UTIL works with triggers and there is a demo in Morgan's Library demonstrating it (www.psoug.org - OWA_UTIL.WHO_CALLED_ME).
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Apr 09 2008 - 15:08:26 CDT