Home » Developer & Programmer » Forms » how to retrieve IP address of machine (forms 6i)
how to retrieve IP address of machine [message #288333] Mon, 17 December 2007 02:17 Go to next message
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
Member
Hi All,
I want to display the IP address of machine from which the application is running.
Is there any way to retrieve IP add. of computer??

My o.s. is XP & i am using Forms 6i.

Thanks,
Harshal
Re: how to retrieve IP address of machine [message #288340 is a reply to message #288333] Mon, 17 December 2007 02:32 Go to previous messageGo to next message
hamidmahmood
Messages: 30
Registered: August 2006
Member
use this query


select sys_context('USERENV','ip_address') into :filed_name
from dual;

Re: how to retrieve IP address of machine [message #288355 is a reply to message #288333] Mon, 17 December 2007 03:13 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you, however, need to obtain information about the client machine, check this article.
Re: how to retrieve IP address of machine [message #288574 is a reply to message #288355] Tue, 18 December 2007 01:23 Go to previous messageGo to next message
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
Member
Hey Thanks very much all.
Re: how to retrieve IP address of machine [message #288663 is a reply to message #288574] Tue, 18 December 2007 04:47 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

select sys_context('USERENV','ip_address')into :ip_address
from dual;


its giving error sys_context must be declared.
Forms 6i
Re: how to retrieve IP address of machine [message #288666 is a reply to message #288663] Tue, 18 December 2007 04:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In that case, create a database function (which would do the job with the SYS_CONTEXT) and call it from the form.
Re: how to retrieve IP address of machine [message #288893 is a reply to message #288333] Wed, 19 December 2007 00:39 Go to previous messageGo to next message
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
Member
hey thanx Littlefoot.

But thats what i did.

i got the same error when i use
select sys_context('USERENV','ip_address')
into :ip_address
from dual;

i create database function & called it from form.


Regards,
Harshal

Re: how to retrieve IP address of machine [message #289144 is a reply to message #288893] Wed, 19 December 2007 19:17 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
As I said in http://www.orafaq.com/forum/t/94230/67467/ "If you are using 10g you can use WebUtil_ClientInfo.Get_IP_Address"

David
Previous Topic: How to change jinitiator icon
Next Topic: unlock record
Goto Forum:
  


Current Time: Thu Dec 08 22:17:11 CST 2016

Total time taken to generate the page: 0.07488 seconds