| General Information |
| Purpose |
Provides procedures to support internet addressing |
| Source |
{$ORACLE_HOME}/rdbms/admin/utlinad.sql |
| First Available |
8.1.7 |
| Dependencies |
|
| 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; |
