Oracle | UTL

Oracle UTL_INADDR Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

AUTHID CURRENT_USER

Dependencies

DBMS_ISCHED

DBMS_ISCHED_REMOTE_ACCESS

UTL_INA_LIB

Documented Yes

Exceptions

Error Code	Reason
ORA-24247	network_access_denied: Network privileges issue
ORA-29257	unknown_host: Host not found

First Available 8.1.7

Security Model Owned by SYS with EXECUTE granted to DVSYS, and PUBLIC

Source {$ORACLE_HOME}/rdbms/admin/utlinad.sql

Subprograms

GET_HOST_ADDRESS

GET_HOST_NAME

GET_HOST_ADDRESS

Retrieves an IP address given the host name utl_inaddr.get_host_address(host IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;

SELECT utl_inaddr.get_host_address('washington.edu');

      

      SELECT utl_inaddr.get_host_address('www.oracle.com');

Retrieve IP address of Oracle client SELECT sid, machine, utl_inaddr.get_host_address(SUBSTR(machine, INSTR(machine,'\')+1)) ip FROM gv$session WHERE type = 'USER' AND username IS NOT NULL;

GET_HOST_NAME

Retrieves a host name given the IP Address utl_inaddr.get_host_name(ip IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;

SELECT utl_inaddr.get_host_name('140.142.15.233');