Re: ip address of the instance?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 16 Mar 2004 19:18:48 +0000
Message-ID: <eoke509s5ru2frtfk8t36g6mskefisdpa4@4ax.com>

On Tue, 16 Mar 2004 10:34:11 -0500, Dom <roqetman_at_hotmail.com> wrote:

>Is there anyway in pl/sql to determine the ip address of the machine
>that runs the oracle instance you're connected to?
>The reason I need this is that I have an instance running an a machine
>that gets it's ip address via DHCP, and it could change, but I want a
>scheduled job to run within the database that tells me if the ip address
> has changed.

Look up UTL_INADDR.

-- 
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

Received on Tue Mar 16 2004 - 13:18:48 CST