Re: IP address of a client

In article <1qsg7.7376$3q.258125_at_news010.worldonline.dk>, "Ove says...
>
>Hi all
>We are using an oracle DB running on a HP9000 unix 10.2.
>We connect from a Navision XAL MRP program, as far as I can see each client
>connection is generating a process on the unix server, is there a way I can
>get the IP address of the connected client?
>

sigh, never a version....

select sys_context( 'USERENV', 'IP_ADRESSS' ) from dual;

works in 8i and up.

>MVH
>Ove Hvam Andersen
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp