Home » SQL & PL/SQL » SQL & PL/SQL » Problem with getting IP address .... (oracle 10g)
Problem with getting IP address .... [message #425023] Wed, 07 October 2009 03:39 Go to next message
rahulpatkiji
Messages: 5
Registered: October 2009
Junior Member
Hello All,

I m facing a problem with getting IP address of machine using oracle 10g.
I execute follwing commands.. but there is no output.

SQL> SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') from dual;

SYS_CONTEXT('USERENV','IP_ADDR
--------------------------------------------------------------------------------

SQL> select dbms_standard.client_ip_address from dual;

CLIENT_IP_ADDRESS
--------------------------------------------------------------------------------

also created function as posted in other forums..
but could not output.

so please help me.

Thanks.
Re: Problem with getting IP address .... [message #425032 is a reply to message #425023] Wed, 07 October 2009 04:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is your configuration?
Server and client version (4 decimals)?
Remote or local connection?
Is client program really SQL*Plus?

Regards
Michel

[Updated on: Wed, 07 October 2009 04:23]

Report message to a moderator

Re: Problem with getting IP address .... [message #425046 is a reply to message #425032] Wed, 07 October 2009 05:20 Go to previous messageGo to next message
rahulpatkiji
Messages: 5
Registered: October 2009
Junior Member
I m using oracle 10g with forms 6i and os is windows XP.
It's local connection.
These command are execute on sql plus .
Re: Problem with getting IP address .... [message #425048 is a reply to message #425046] Wed, 07 October 2009 05:28 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
If you use a local connection (without connecting through the listener) then "IP_ADDRESS" is empty, since you don't connect over TCP/IP.
Re: Problem with getting IP address .... [message #425052 is a reply to message #425048] Wed, 07 October 2009 05:42 Go to previous message
rahulpatkiji
Messages: 5
Registered: October 2009
Junior Member
Thanks All,
Now it works..
Previous Topic: problem with dbms_file_transer
Next Topic: insert using row no
Goto Forum:
  


Current Time: Fri Feb 07 00:02:08 CST 2025