Internet Address Package

The UTL_INADDR package has two functions:

• get_host_name()

• get_host_address()

get_host_name()

Purpose

Retrieves name of local host.

Syntax

FUNCTION get_host_name RETURN VARCHAR2;

Comments

None

get_host_address()

Purpose

Retrieves the IP address of a host

Syntax

FUNCTION get_host_address (host IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2; 

Parameter

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.