| General Information |
| Purpose |
Provides procedures to support internet addressing |
| Source |
{$ORACLE_HOME}/rdbms/admin/utlinad.sql |
| First Available |
8.1.7 |
| Dependencies |
| DBMS_ISCHED |
MGMT_DB_LL_METRICS |
UTL_INA_LIB |
|
| Exceptions |
| Error Code |
Exception Name |
Reason |
| ORA-24247 |
network_access_denied |
Network privileges issue |
| ORA-29257 |
unknown_host |
Host not found |
|
| Security Model |
Execute is granted to PUBLIC |
| 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; |
