Home » Developer & Programmer » Forms » how to get user_ip address ? (Forms 6i)
how to get user_ip address ? [message #396262] Sun, 05 April 2009 23:28 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hello,
My Forms version

Forms [32 Bit] Version 6.0.8.25.2 (Production)
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
     With the Partitioning, OLAP and Oracle Data Mining options
     JServer Release 9.2.0.8.0 - Production
Oracle Toolkit Version 6.0.8.25.0 (Production)
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #1459 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 6.0.7.1.0 - Production
Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)
Oracle Tools GUI Utilities Version 6.0.8.25.0 (Production)
Oracle Multimedia Version 6.0.8.25.0 (Production)
Oracle Tools Integration Version 6.0.8.18.0 (Production)
Oracle Tools Common Area Version 6.0.8.18.0
Oracle CORE Version 4.0.6.0.0 - Production



When i use this Sys_context i am getting following error.

Sys_context must be declared



PLease help to how to get the user Ip address.

Kanish
Re: how to get user_ip address ? [message #396319 is a reply to message #396262] Mon, 06 April 2009 02:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a stored procedure (function) which uses SYS_CONTEXT; use this ufnction's result in your form.
Re: how to get user_ip address ? [message #396331 is a reply to message #396262] Mon, 06 April 2009 02:44 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

You are right Littlefoot

Thanks

Kanish
Re: how to get user_ip address ? [message #396357 is a reply to message #396262] Mon, 06 April 2009 05:08 Go to previous message
dushnkenjoy
Messages: 3
Registered: April 2009
Location: India
Junior Member

You can use

WebUtil_ClientInfo package with Get_IP_Address function
which will return IP address of the client maching where exactly form application is being open.

WebUtil_ClientInfo.Get_IP_Address
Previous Topic: Master Detail Form
Next Topic: ORA-01422
Goto Forum:
  


Current Time: Sun Dec 11 08:12:26 CST 2016

Total time taken to generate the page: 0.11427 seconds