How to trigger which program updated a table ?

From: Maija-Leena <>
Date: Wed, 23 Sep 2009 06:50:07 GMT
Message-ID: <zyjum.15$>

I need to log some updates and I would like to do it using a trigger which inserts a line to a logtable. I need to know which application (sqlplus, java, toad etc) was used to make the update. I've studied sys_context but didn't find that information. Toad's Session Browser shows programs that are connected to the database, so I think it's possible. Do You know how ?

Thanks !

Maija-Leena Received on Wed Sep 23 2009 - 01:50:07 CDT

Original text of this message