Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sys_context returns null for 'USERENV'

457994Jan 23 2006 — edited Mar 23 2009
SELECT SYS_CONTEXT ('USERENV', 'OS_USER')
FROM DUAL;
returns null when run in Raptor.

returns os_user id when run int SQL*PLus

We use this in triggers to track who created/modified a record.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2009
Added on Jan 23 2006
#sql-developer
39 comments
13,440 views