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

From: DA Morgan <damorgan@xxxxxxxxx>
Date: Fri, 27 Apr 2007 07:43:16 -0700

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

Additionally you can use DBMS_APPLICATION_INFO to set ACTION and DBMS_SESSION's SET_CONTEXT.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

References:
- retrieving the location of a database trigger call..
  - From: Nigel Curtis

Prev by Date: Re: group by clause ordering
Next by Date: Re: Why Oracle don't have AUTO_INCREMENT as in MySQL
Previous by thread: Re: retrieving the location of a database trigger call..
Next by thread: Re: retrieving the location of a database trigger call..
Index(es):
- Date
- Thread