Re: Triggers
From: <fitzjarrell_at_cox.net>
Date: Thu, 12 Jun 2008 10:20:56 -0700 (PDT)
Message-ID: <0d5147e5-4f86-48cc-8178-428ca6879cc8@w7g2000hsa.googlegroups.com>
Date: Thu, 12 Jun 2008 10:20:56 -0700 (PDT)
Message-ID: <0d5147e5-4f86-48cc-8178-428ca6879cc8@w7g2000hsa.googlegroups.com>
On Jun 12, 9:39 am, Mtek <m..._at_mtekusa.com> wrote:
> Hi,
>
> We have an update trigger on a table for some auditing purposes. Is
> there a way to find the actual program that updated the underlying
> table? I hope it is not like 40 lines of code....... :)
>
> Thanks!
>
> John
You can try this, from Tom Kyte:
http://asktom.oracle.com/tkyte/who_called_me/who.sql
And, sorry, it is about 40 lines of code to create the procedure and function.
David Fitzjarrell Received on Thu Jun 12 2008 - 12:20:56 CDT