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?