UTL_INADDR

The UTL_INADDRpackage provides a PL/SQL procedures to support internet addressing. It provides an API to retrieve host names and IP addresses of local and remote hosts.

This chapter contains the following topics:

• Security Model

• Exceptions

• Examples

• Summary of UTL_INADDR Subprograms

UTL_INADDR Security Model

This package is an invoker’s rights package, which means that the invoking user must be granted the connect privilege in the access control list assigned to the remote network host to which he or she wishes to connect.

Note: For more information about managing fine-grained access, see Oracle Database Security Guide.

UTL_INADDR Exceptions

This table describes cxceptions raised by UTL_INADDR subprograms.

Table 1 Exception - Internet Address Package

Number	Exception	Description
ORA-24247	NETWORK_ACCESS_DENIED	Access to network is denied.
ORA-29257	UNKNOWN_HOST	The host is unknown.

UTL_INADDR Examples

This UTL_INADDR example retrieves the local host name and IP address.

SET serveroutput on
BEGIN
  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME);  -- get local host name
  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS);  -- get local IP addr
END;
/

Summary of UTL_INADDR Subprograms

This table lists the UTL_INADDR subprograms and briefly describes them.

Table 2 UTL_INADDR Package Subprograms

Subprogram	Description
GET_HOST_ADDRESS Function	Retrieves the IP address of the local or remote host given its name
GET_HOST_NAME Function	Retrieves the name of the local or remote host given its IP address

GET_HOST_ADDRESS Function

This function retrieves the IP address of the specified host.

Syntax

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

Parameters

Table 3 GET_HOST_ADDRESS Function Parameters

Parameter	Description
host	The name of the host to retrieve the IP address.

Return Values

Table 4 GET_HOST_ADDRESS Function Return Values

Parameter	Description
host_address	The IP address of the specified host, or that of the local host if host is NULL.

Exceptions

UNKNOWN_HOST: The specified IP address is unknown

Usage Notes

The permission to obtain the host name or IP address of the current host is controlled by the resolve privilege on LOCALHOST.

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 host_name VARCHAR2;

Parameters

Table 5 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.

Return Values

Table 6 GET_HOST_NAME Function Return Values

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

Exceptions

UNKNOWN_HOST: The specified IP address is unknown

Usage Notes

The permission to obtain the host name or IP address of the current host is controlled by the resolve privilege granted through DBMS_NETWORK_ACL_ADMIN on LOCALHOST.