OraFAQ Forum: Forms » How can we get client ip address and machine name in oralce forms 10g without webutil

Home » Developer & Programmer » Forms » How can we get client ip address and machine name in oralce forms 10g without webutil

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

How can we get client ip address and machine name in oralce forms 10g without webutil [message #596781]

Thu, 26 September 2013 05:35

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How can we get client ip address and machine name in oralce forms 10g without webutil

Thanks

Report message to a moderator

Re: How can we get client ip address and machine name in oralce forms 10g without webutil [message #596784 is a reply to message #596781]

Thu, 26 September 2013 05:49

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Have a look at this OTN forum discussion; maybe you'll find something useful.

Report message to a moderator

Re: How can we get client ip address and machine name in oralce forms 10g without webutil [message #596805 is a reply to message #596781]

Thu, 26 September 2013 07:27

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select nvl(sys_context ('USERENV','IP_ADDRESS'),
           utl_inaddr.get_host_address (sys_context ('USERENV','SERVER_HOST'))
          ) ip,
       utl_inaddr.get_host_name (SYS_CONTEXT ('USERENV','IP_ADDRESS')) host
from dual
/

Report message to a moderator

Re: How can we get client ip address and machine name in oralce forms 10g without webutil [message #596811 is a reply to message #596805]

Thu, 26 September 2013 07:48

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

its works on sql level but not work in when new form instance trigger

Report message to a moderator

Previous Topic:	Chatting Application
Next Topic:	Can We Create Forms Runtime in Oracle Forms 10g Like Oracle Forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 17:46:58 CDT 2024