OraFAQ Forum: Forms » IP Address in forms10g

Home » Developer & Programmer » Forms » IP Address in forms10g

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

IP Address in forms10g [message #235223]

Fri, 04 May 2007 06:59

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

How to find the system name in forms 10g.

I have oracle 8i as backend.

Thanks,
Srinivas

Report message to a moderator

Re: IP Address in forms10g [message #235477 is a reply to message #235223]

Sun, 06 May 2007 13:57

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.

Report message to a moderator

Re: IP Address in forms10g [message #235612 is a reply to message #235477]

Mon, 07 May 2007 07:02

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

hi NATVA,
It works.
Ashu

Report message to a moderator

Re: IP Address in forms10g [message #235642 is a reply to message #235223]

Mon, 07 May 2007 09:32

srinivas.k2005
Messages: 404
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

Report message to a moderator

Re: IP Address in forms10g [message #235750 is a reply to message #235642]

Mon, 07 May 2007 19:05

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 .

Report message to a moderator

Re: IP Address in forms10g [message #235788 is a reply to message #235223]

Tue, 08 May 2007 00:48

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

hi,

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

thanks,
Srinivas

Report message to a moderator

Previous Topic:	d2k
Next Topic:	How to store date values? (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 13:13:37 CST 2025