Definition:
In Oracle, UTL_INADDR is an Oracle package used to support internet addressing. It contains two functions which return the server machine name and its IP address. If the operation fails, it raises the HOST_ADDRESS exception.
The package UTL_INADDR contains two subprograms:
- GET_HOST_ADDRESS: Returns the IP address of the server machine.
- GET_HOST_NAME: Returns the machine name.
Example Usage:
The SELECT statement below use the UTL_INADDR subprograms to retrieve the server name and IP address.
SQL> exec DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME);
IN-L-NLAA010009
PL/SQL procedure successfully completed.
SQL> exec DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS);
10.140.233.84
PL/SQL procedure successfully completed.
Related Links:
