Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

UTL_INADDR , 2 of 2


Summary of UTL_INADDR Subprograms

Table 97-2 UTL_INADDR Subprograms
Subprogram Description

get_host_name Function

Retrieves the name of the local or remote host given its IP address.

get_host_address Function

Retrieves the IP address of the local or remote host given its name.

get_host_name Function

This function retrieves the name of the local or remote host given its IP address.

Syntax

UTL_INADDR.GET_HOST_NAME (
   ip  IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;

Parameters

Table 97-3 get_host_name Function Parameters
Parameter Description

ip

The IP address of the host used to determine its host name. If ip is not NULL, the official name of the host with its domain name is returned. If this is NULL, the name of the local host is returned and the name does not contain the domain to which the local host belongs.

Returns

The name of the local or remote host of the specified IP address.

Exceptions

unknown_host. The specified IP address is unknown.

get_host_address Function

This function retrieves the IP address of a host.

Syntax

UTL_INADDR.GET_HOST_ADDRESS (
   host  IN VARCHAR2 DEFAULT NULL) 
RETURN VARCHAR2; 

Parameters

Table 97-4 get_host_address Function Parameters
Parameter Description

host (IN)

The name of the host to retrieve the IP address. If host is NULL, this function returns the IP address of the local host.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback