CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle UTL_INADDR
Version 11.1
 
General Information
Purpose Provides procedures to support internet addressing
Source {$ORACLE_HOME}/rdbms/admin/utlinad.sql
First Available 8.1.7
Dependencies
DBMS_ISCHED UTL_INA_LIB
Exceptions
Exception Name Error Code Reason

network_access_denied

24247 Network privileges issue

unknown_host

29257 Host not found
Required Object Privilege GRANT execute ON utl_inaddr TO <schema_name>;
GRANT execute ON utl_inaddr TO uwclass;
 
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;
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
UTL_NETWORK_ACL_ADMIN
UTL_NETWORK_ACL_UTILITY
SYS_CONTEXT
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [323 users online]    © 2010 psoug.org