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

On Jun 12, 9:39*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
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

On Jun 12, 9:39*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
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

On Jun 12, 9:39*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
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

On Jun 12, 9:39*am, Mtek <m... (AT) mtekusa (DOT) com> wrote:
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

Mtek wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Mtek wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Mtek wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Mtek wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org