Page 1 of 1

Problem with Sys_Context

Posted: Wed Jun 21, 2006 6:19 am
by mirza_rehan
I am trying to get Os_User name with this Sql Statement, but it give me error i m user "<b>Oracle8i Enterprise Edition Release 8.1.5.0.0</b>"

SQL> SELECT sys_context('USERENV', 'OS_USER') FROM dual;
SELECT sys_context('USERENV', 'OS_USER') FROM dual
*
ERROR at line 1:
ORA-02003: invalid USERENV parameter

is any other way to get Os_User?? except this one????

<b>select osUser from v$Session
where UserName = User
and status = 'ACTIVE';</b>

Thanks in advance

take care

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family