Home » Developer & Programmer » Forms » FIND ip ADDRESS OF PC (ORACLE9I ON LINUX,FORM6I ON XP)
FIND ip ADDRESS OF PC [message #325474] Fri, 06 June 2008 05:30 Go to next message
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
Re: FIND ip ADDRESS OF PC [message #325479 is a reply to message #325474] Fri, 06 June 2008 05:44 Go to previous messageGo to next message
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
Re: FIND ip ADDRESS OF PC [message #325493 is a reply to message #325479] Fri, 06 June 2008 06:35 Go to previous messageGo to next message
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
Re: FIND ip ADDRESS OF PC [message #325497 is a reply to message #325493] Fri, 06 June 2008 06:46 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
Re: FIND ip ADDRESS OF PC [message #325798 is a reply to message #325474] Sun, 08 June 2008 23:25 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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
Re: FIND ip ADDRESS OF PC [message #326755 is a reply to message #325798] Thu, 12 June 2008 09:00 Go to previous messageGo to next message
anilsharma
Messages: 10
Registered: June 2008
Location: INDIA
Junior Member

mm_kanish05 wrote on Mon, 09 June 2008 09:55
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

Re: FIND ip ADDRESS OF PC [message #326756 is a reply to message #325798] Thu, 12 June 2008 09:05 Go to previous messageGo to next message
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

Re: FIND ip ADDRESS OF PC [message #401453 is a reply to message #325474] Tue, 05 May 2009 01:51 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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
Re: FIND ip ADDRESS OF PC [message #401902 is a reply to message #401453] Wed, 06 May 2009 21:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This is a Citrix question. Ask them how they get the IP address of the user's PC.

David
Re: FIND ip ADDRESS OF PC [message #401904 is a reply to message #325474] Wed, 06 May 2009 22:05 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: FIND ip ADDRESS OF PC [message #401954 is a reply to message #401904] Thu, 07 May 2009 02:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Date Format change During the Insert
Next Topic: calling a report through forms
Goto Forum:
  


Current Time: Thu Dec 08 00:40:28 CST 2016

Total time taken to generate the page: 0.05187 seconds