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.