Oracle UTL_INADDR
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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_GSM_CLOUDADMIN DBMS_ISCHED MGMT_DB_LL_METRICS
DBMS_GSM_DBADMIN DBMS_MACADM 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 PUBLIC and ORACLE_OCM
Source {$ORACLE_HOME}/rdbms/admin/utlinad.sql
Subprograms
 
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')
FROM dual;

SELECT utl_inaddr.get_host_address('www.oracle.com')
FROM dual;
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')
FROM dual;

Related Topics
DBMS_NETWORK_ACL_ADMIN
DBMS_NETWORK_ACL_UTILITY
Packages
SYS_CONTEXT
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved