OraFAQ Forum: Forms » FIND ip ADDRESS OF PC

Home » Developer & Programmer » Forms » FIND ip ADDRESS OF PC (ORACLE9I ON LINUX,FORM6I ON XP)

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

FIND ip ADDRESS OF PC [message #325474]

Fri, 06 June 2008 05:30

anilsharma
Messages: 10
Registered: June 2008
Location: INDIA

Junior Member

HELLO
I AM WANT TO STORE MY PC IP ADDRESS IN A FIELD BUT I D'NOT HOW i FIND THIS,ANY BODY TELL IT IS POSSIBLE OR NOT
SUPPOSE MY ip ADDRESS IS 300.445.455.90
THANKS
ANIL SHARMA

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #325479 is a reply to message #325474]

Fri, 06 June 2008 05:44

sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi

Member

SELECT SYS_CONTEXT('USERENV','IP_ADDRESS')
		INTO :field_name FROM DUAL

This works fine on windows based Database and Forms XP

Regards,
Kashif Ali

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #325493 is a reply to message #325479]

Fri, 06 June 2008 06:35

anilsharma
Messages: 10
Registered: June 2008
Location: INDIA

Junior Member

sir
i try it on sqlplus the result is correct but when i try it on form then message appear
SYS_CONTEXT must be declare
thanks

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #325497 is a reply to message #325493]

Fri, 06 June 2008 06:46

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

Senior Member
Account Moderator

Create a database function which will use SYS_CONTEXT; use newly created function in a form. Something like presented in this thread.

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #325798 is a reply to message #325474]

Sun, 08 June 2008 23:25

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi
Nice, But im getting server ip address not my machine ip address.

When i execute the above query

im getting
192.9.200.1
It is my server ip addresss(where oracle home)

my machine ip address is

192.9.200.4

Can i know why?

Kanish

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #326755 is a reply to message #325798]

Thu, 12 June 2008 09:00

anilsharma
Messages: 10
Registered: June 2008
Location: INDIA

Junior Member

mm_kanish05 wrote on Mon, 09 June 2008 09:55

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #326756 is a reply to message #325798]

Thu, 12 June 2008 09:05

anilsharma
Messages: 10
Registered: June 2008
Location: INDIA

Junior Member

hi
i get by my machine ip address with these step
first i create database function :

FUNCTION get_ipaddress RETURN varchar2 IS
BEGIN
RETURN sys_context('USERENV', 'IP_ADDRESS');
END;

then call it in form field such as

:block_name.field_name := get_ipaddress;

thanks to all for help
ANIL SHARMA

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #401453 is a reply to message #325474]

Tue, 05 May 2009 01:51

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Hi all,

Our end users are accessing application via internet or using citrix server. I am getting ip address of citrix server instead of actual user ip address. How to get the get actual user ip address instead masked ip address? or can get mac address?

kanish

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #401902 is a reply to message #401453]

Wed, 06 May 2009 21:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

This is a Citrix question. Ask them how they get the IP address of the user's PC.

David

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #401904 is a reply to message #325474]

Wed, 06 May 2009 22:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If the application utilizes "connection pooling", then you can not reliably obtain client's IP#.

If each client has its own "dedicated" connection, then the middle tier application has the opportunity to obtain the IP# & store it into CLIENT_INFO field of V$SESSION.

Report message to a moderator

Re: FIND ip ADDRESS OF PC [message #401954 is a reply to message #401904]

Thu, 07 May 2009 02:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

BS,

I don't think your second statement works for Citrix as the sessions run on a machine 'inside' and only the image is transmitted to the 'outside', and it is IP address of the 'outside' machine that I think the OP is wanting to find.

David

Report message to a moderator

Previous Topic:	Date Format change During the Insert
Next Topic:	calling a report through forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 03:25:28 CST 2025