Home » Developer & Programmer » Forms » Oracle Form 4.5
Oracle Form 4.5 [message #423498] Thu, 24 September 2009 15:47 Go to next message
biswajit
Messages: 19
Registered: September 2009
Location: USA
Junior Member
Hi,

Please tell me how I can get Windows OS User login from
Form 4.5. For example In 10g we can use webutil/sys_context.
My problem is I need to verify OS user name. sys_context is not working for Oracle Form 4.5.


Please Help me...

NB: David Please help me.

Thanks
Biswajit
Re: Oracle Form 4.5 [message #423531 is a reply to message #423498] Fri, 25 September 2009 02:17 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you could write a database function which uses SYS_CONTEXT and call it from the form.
Re: Oracle Form 4.5 [message #423591 is a reply to message #423531] Fri, 25 September 2009 07:54 Go to previous messageGo to next message
biswajit
Messages: 19
Registered: September 2009
Location: USA
Junior Member
Database function with sys_context is not working in forms 4.5


Any other way please tell me..
Re: Oracle Form 4.5 [message #424751 is a reply to message #423591] Mon, 05 October 2009 15:54 Go to previous messageGo to next message
biswajit
Messages: 19
Registered: September 2009
Location: USA
Junior Member
Any one please help me this issue.

Thanks
Biswajit
Re: Oracle Form 4.5 [message #426804 is a reply to message #424751] Mon, 19 October 2009 18:08 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try the following:
   select upper(osuser), upper(terminal)
     into v_osuser, v_terminal
     from v$session
    where sid = (select distinct sid
                            from v$mystat);

David
Previous Topic: migration from IDS 6i to 10g
Next Topic: Problem when using MScomm32.ocx in form 6i
Goto Forum:
  


Current Time: Sat Dec 03 01:17:02 CST 2016

Total time taken to generate the page: 0.04944 seconds