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
On Apr 27, 12:22 pm, Nigel Curtis <cn_cur
@runbox.com> 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
There are numerous attributes you can retrieve using the SYS_CONTEXT
function.
One of them is MODULE. This is the module you can set using
DBMS_APPLICATION_INFO.
Hth
--
Sybrand Bakker
Senior Oracle DBA
-----------------------------------------------Reply-----------------------------------------------
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
damor
@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org -----------------------------------------------Reply-----------------------------------------------
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:3... Gints Plivna
http://www.gplivna.eu
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
