Re: How do I get a client's IP Address?

You can not find the TCP address in the ORACLE dictionary. But if you have the machine name, you can do PING <machine name> from the OS command line and the response of the ping command will contain the address of the machine.

Example;
C:> Ping degoba
Reply from 162.345.678.90: bytes 32 time<10ms TTL=128

This is on NT 4.0 OS. On Unix may have a slightly different format.

Alex Stamenov

acorrea_at_my-dejanews.com wrote in message <6t3ho9$j5a$1_at_nnrp1.dejanews.com>...
>Hi,
>
>I need to get a client machine's IP Address from Oracle somehow and I was
>wondering if anyone could help me figure out how to do it. I need to
>uniquely identify a client machine's connection from within Oracle. I was
>hoping to use the machine's IP Address, but I can't find where Oracle might
>have stored it during the session. From what I understand the V$SESSION
>table holds the client Machine Name, but not the IP Address. If anyone can
>help me with this I would greatly appreciate it.
>
>Thanks in advance
>Artie Correa
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 08 1998 - 15:47:32 CDT