OraFAQ Forum: Forms » how to retrieve IP address of machine

Home » Developer & Programmer » Forms » how to retrieve IP address of machine (forms 6i)

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

how to retrieve IP address of machine [message #288333]

Mon, 17 December 2007 02:17

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

Report message to a moderator

Re: how to retrieve IP address of machine [message #288340 is a reply to message #288333]

Mon, 17 December 2007 02:32

hamidmahmood
Messages: 30
Registered: August 2006

Member

use this query

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

Report message to a moderator

Re: how to retrieve IP address of machine [message #288355 is a reply to message #288333]

Mon, 17 December 2007 03:13

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

Senior Member
Account Moderator

If you, however, need to obtain information about the client machine, check this article.

Report message to a moderator

Re: how to retrieve IP address of machine [message #288574 is a reply to message #288355]

Tue, 18 December 2007 01:23

harshalonline22
Messages: 74
Registered: March 2007
Location: Pune

Member

Hey Thanks very much all.

Report message to a moderator

Re: how to retrieve IP address of machine [message #288663 is a reply to message #288574]

Tue, 18 December 2007 04:47

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

Report message to a moderator

Re: how to retrieve IP address of machine [message #288666 is a reply to message #288663]

Tue, 18 December 2007 04:49

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

Report message to a moderator

Re: how to retrieve IP address of machine [message #288893 is a reply to message #288333]

Wed, 19 December 2007 00:39

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

Report message to a moderator

Re: how to retrieve IP address of machine [message #289144 is a reply to message #288893]

Wed, 19 December 2007 19:17

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Previous Topic:	How to change jinitiator icon
Next Topic:	unlock record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 03:32:44 CST 2025