OraFAQ Forum: Forms » how to get current session id

Home » Developer & Programmer » Forms » how to get current session id

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

how to get current session id [message #220729]

Wed, 21 February 2007 16:03

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

i want to know the sesion id when the user run the form .
i tried to use V$session but it retrive all sessions
i want to retrive the session with the form open when it run.

it's urgent
please help
thanks

Report message to a moderator

Re: how to get current session id [message #220797 is a reply to message #220729]

Thu, 22 February 2007 03:11

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

SELECT se.sid,USERENV('SESSIONID')
  FROM   v$session se
 WHERE se.audsid = USERENV('SESSIONID');

By
Vamsi

[Updated on: Thu, 22 February 2007 03:34]

Report message to a moderator

Re: how to get current session id [message #243082 is a reply to message #220729]

Wed, 06 June 2007 00:30

yahya_mukhtar
Messages: 12
Registered: June 2007
Location: pakistan

Junior Member

select userenv('session_id') from dual

Report message to a moderator

Previous Topic:	Error while on Date picker
Next Topic:	How to call Procedure in Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 09:15:24 CDT 2025