Problem with Sys_Context
Posted: Wed Jun 21, 2006 6:19 am
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
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