Problem with getting IP address .... [message #425023] |
Wed, 07 October 2009 03:39  |
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.
|
|
|
|
|
|
|