Quick Search:
 
 The Oracle PL/SQL UTL_INADDR Function      [Return To Index] Jump to:  

Term: UTL_INADDR

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:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org