Something like SYS_CONTEXT('USERENV', 'PROGRAM') ?
Oracle 9204:
I'm trying to make a log table taht will log, among other thigns, the app the user was using at the time.
V$SESSION shows me "program" column, but this is not available in the SYS_CONTEXT through my best guesses.
Short of creating my own function that will SELECT program FROM v$session WHERE audsid = SYS_CONTEXT('USERENV', 'SESSIONID') and then using that function as a DEFAULT in my table def, what can I do? Is this info avail in a system function anywhere?