Problem with Sys_Context

To discuss Oracle Forms & Reports related technical issues.
Post Reply
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Problem with Sys_Context

Post 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
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest