Oracle PL/SQL get server's IP v4?

How can I get the IP v4 Of the server by using PL/SQL ? UTL_INADDR.GET_HOST_ADDRES开发者_StackOverflow社区S gives me IPv6, while I need IPv4

what I did I disabled the IPv6 on the sever, still it's bringing me the the IPv6 of the "Tunnel adapter Teredo Tunneling Pseudo-Interface" !!

I'm using Oracle 11g database on Windows 2008 R2 Server

UTL_INADDR.GET_HOST_ADDRESS returns just an ip which is nonsense since a server may have dozens of them. Probably your best bet it's to create a pl/sql wrapper of a Java method which returns every possible ip address using NetworkInterface.getNetworkInterfaces();