-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|