Re: retrieving the location of a database trigger call..

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 27 Apr 2007 10:52:16 -0700
Message-ID: <1177696336.701185.46740@t38g2000prd.googlegroups.com>

Nigel Curtis wrote:
> Hi - in a 10g Oracle 'Before Insert or Update' trigger is there any
> way of find the source of the insert/update...? That is, the name of
> any background process, SQL*Plus script or form which may have done
> the insert/update..?
>
> If such information isn't lost I'd like to try and use it as a
> condition within the trigger but can't see any way of retrieving it.
>
> many thanks, nigel

check dbms_utility.format_call_stack
and
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:382218730166

Gints Plivna
http://www.gplivna.eu Received on Fri Apr 27 2007 - 12:52:16 CDT