Prev: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE
Next: Views
From: Mtek on 12 Jun 2008 10:39

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
From: fitzjarrell on 12 Jun 2008 13:20
On Jun 12, 9:39 am, Mtek <m...(a)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
From: DA Morgan on 12 Jun 2008 17:28
Mtek 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

http://www.psoug.org/reference/owa_util.html
scroll down to WHO_CALLED_ME.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan(a)x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 | 
Pages: 1
Prev: Oracle Spatial SDO Aggregate Union fails with ORA-29913 ODCIAGGREGATEMERGE
Next: Views