Trigger variables 
Author Message
 Trigger variables
Trying to find a list of variables available to a trigger. It is an
update after trigger. Basically we would like to insert a row in a
table after the update and would like the column to not whether or not
it was SQLPLUS. In our shop if the trigger could get the OSUSER we can
determine this.

I would like to be able to grab information like OSUSER from v$session
on the individual who causes the trigger to fire.

Might be a lot of overhead but can it be done simply?



Mon, 24 May 2004 01:48:45 GMT
 Trigger variables

[...]
Quote:
>I would like to be able to grab information like OSUSER from v$session
>on the individual who causes the trigger to fire.

[...]

Hi,
as always you forgot to mention what oracle release are you using.

If 8i so try do next:
SELECT SYS_CONTEXT('USERENV', 'OS_USER') FROM DUAL;

Operating system username of the client process that initiated the database
session. For more attributes see the description of SYS_CONTEXT function.

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com



Mon, 24 May 2004 12:43:42 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Trigger variables in xp_sendmail

2. Trigger variables in xp_sendmail

3. Triggers/ Variables

4. dynamic trigger variables?

5. Selecting multiple columns into variables in a Trigger

6. Dynamically specifying DataType of Variables in triggers

7. Variable usage in a trigger?

8. Trigger and variable

9. Variable for a table name in a trigger (TSQL)

10. Insert Triggers: Extracting values into variables

11. trigger and variables

12. Triggers and variables


 
Powered by phpBB® Forum Software