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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: translate an ip

Re: translate an ip

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 29 Aug 2007 06:58:28 -0700
Message-ID: <bf46380708290658p28f1e205wba422a98b7a10889@mail.gmail.com>


On 8/28/07, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
>
> Hello experts,
>
> I am trying to build a function to translate an IP address into its name,
> or vice versa. I have a mixed bag of IP addresses and DNS names, all culled
> from AUD$ history tables. What I need is a consistent format, either IP or
> DNS name, so I can consolidate the information. I am trying to use
> utl_inaddr.get_host_name. It works, but if it encounters an IP that it
> can't translate, my SQL statement fails. The same for using
> utl_inaddr.get_host_address. What I have so far is below. It compiles, but
> it doesn't catch the error. What I need is something that will either
> translate the address, or else return the original value. I would
> appreciate any help you might have to offer.
>
>

What is the nature of the failure?

IP or hostname that no longer exists?

Or something else?

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 29 2007 - 08:58:28 CDT

Original text of this message

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