OraFAQ Forum: Forms » Oracle Form 4.5

Home » Developer & Programmer » Forms » Oracle Form 4.5

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Form 4.5 [message #423498]

Thu, 24 September 2009 15:47

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

Report message to a moderator

Re: Oracle Form 4.5 [message #423531 is a reply to message #423498]

Fri, 25 September 2009 02:17

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Oracle Form 4.5 [message #423591 is a reply to message #423531]

Fri, 25 September 2009 07:54

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..

Report message to a moderator

Re: Oracle Form 4.5 [message #424751 is a reply to message #423591]

Mon, 05 October 2009 15:54

biswajit
Messages: 19
Registered: September 2009
Location: USA

Junior Member

Any one please help me this issue.

Thanks
Biswajit

Report message to a moderator

Re: Oracle Form 4.5 [message #426804 is a reply to message #424751]

Mon, 19 October 2009 18:08

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 03:48:00 CST 2025