OraFAQ Forum: Forms » how to get user

Home » Developer & Programmer » Forms » how to get user_ip address ? (Forms 6i)

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

how to get user_ip address ? [message #396262]

Sun, 05 April 2009 23:28

mm_kanish05
Messages: 493
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

Report message to a moderator

Re: how to get user_ip address ? [message #396319 is a reply to message #396262]

Mon, 06 April 2009 02:03

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

Report message to a moderator

Re: how to get user_ip address ? [message #396331 is a reply to message #396262]

Mon, 06 April 2009 02:44

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

You are right Littlefoot

Thanks

Kanish

Report message to a moderator

Re: how to get user_ip address ? [message #396357 is a reply to message #396262]

Mon, 06 April 2009 05:08

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

Report message to a moderator

Previous Topic:	Master Detail Form
Next Topic:	ORA-01422

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 11:22:26 CST 2025