$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << 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
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>