Re: translate an ip

On 8/28/07, Andrew Kerber <andrew.kerber@xxxxxxxxx> 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

Other related posts: