Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL UTL_INADDR Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 186 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?