Home » SQL & PL/SQL » SQL & PL/SQL » Getting Terminal Id(Machine Name)in Database Trigger Executing in Application Server Environment (Forms [32 Bit] Version 9.0.4.0.19 (Production),Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production, Windows XP)
Getting Terminal Id(Machine Name)in Database Trigger Executing in Application Server Environment [message #398164] Wed, 15 April 2009 08:00 Go to next message
amanyanye
Messages: 5
Registered: March 2008
Junior Member
I would like to populate terminal id into my audit table for changes that happen on a table by the use of a database trigger on table level. The problem is USERENV('Terminal') and SYS_CONTEXT('USERENV','TERMINAL') functions are polulation the server name from which the Trigger EXECUTES. Help.

Regards,

A Manyanye
Re: Getting Terminal Id(Machine Name)in Database Trigger Executing in Application Server Environment [message #398167 is a reply to message #398164] Wed, 15 April 2009 08:07 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2088.htm
Previous Topic: Sorting in Merge
Next Topic: Update query taking long time
Goto Forum:
  


Current Time: Fri Dec 09 00:23:58 CST 2016

Total time taken to generate the page: 0.07852 seconds