Home » Developer & Programmer » Forms » IP Address in forms10g
IP Address in forms10g [message #235223] Fri, 04 May 2007 06:59 Go to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Hi,

How to find the system name in forms 10g.

I have oracle 8i as backend.

Thanks,
Srinivas
Re: IP Address in forms10g [message #235477 is a reply to message #235223] Sun, 06 May 2007 13:57 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
Hi,
Try this to get the IP address ...

select sys_context('userenv','ip_address') from dual;


if this is not working in forms, create a function and return the ip address to the forms , it will work.

Re: IP Address in forms10g [message #235612 is a reply to message #235477] Mon, 07 May 2007 07:02 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi NATVA,
It works.
Ashu
Re: IP Address in forms10g [message #235642 is a reply to message #235223] Mon, 07 May 2007 09:32 Go to previous messageGo to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Hi,

I have oracle 8i,when i ran the query its returning null.
Do I need to set any parameters.

SQL> select sys_context('userenv','ip_address') from dual;

SYS_CONTEXT('USERENV','IP_ADDRESS')
-----------------------------------------------------------------


Thanks,
Srinivas
Re: IP Address in forms10g [message #235750 is a reply to message #235642] Mon, 07 May 2007 19:05 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
You don't need to pass any parameter, are you running on the SQL plus or TOAD. I hope it should work in 8i, but unfortunately i do not have 8i verson .
Re: IP Address in forms10g [message #235788 is a reply to message #235223] Tue, 08 May 2007 00:48 Go to previous message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
hi,

I am working on sql*plus.
I have a personal oracle 8i database.

thanks,
Srinivas
Previous Topic: d2k
Next Topic: How to store date values? (merged)
Goto Forum:
  


Current Time: Sun Dec 04 10:54:59 CST 2016

Total time taken to generate the page: 0.14393 seconds