Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: retrieving the location of a database trigger call..
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_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Apr 27 2007 - 09:43:16 CDT