Re: IP Address

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Mar 2002 14:15:37 +0100
Message-ID: <qus39uo65plgnahbq8ap7pgrs9m83iqp0n@4ax.com>

On Fri, 15 Mar 2002 14:05:42 +0100, Knut Talman <knut.talman_at_mytoys.de> wrote:

>> How can I get, in PL/SQL, the IP number of a connected client? It is
>> possible?
>
>Select the machine name from v$session and use nslookup as a host command to
>find out the IP address.
>
>Regards,
>
>Knut

In 8i and higher it is possible to do it directly with the SYS_CONTEXT function.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 15 2002 - 07:15:37 CST