Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ip address of the instance?

Re: ip address of the instance?

From: Dom <roqetman_at_hotmail.com>
Date: Thu, 18 Mar 2004 08:32:16 -0500
Message-ID: <zxh6c.4$xJ3.58515@news.nyc.globix.net>


Andy Hassall wrote:
> 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.
>

Thank you. Received on Thu Mar 18 2004 - 07:32:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US