The UTL_INADDR package was introduced in Oracle 8.1.6 to provide a means of retrieving host names and IP addresses of remote hosts from PL/SQL.
|chr(10); BEGIN. v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host)
Personally I'd use CHR() to identify the nul values. A nul is an ASCII 0 and CHR() will return the character representation of the number you pass in.
Using getent hosts <host> is incorrect, as for instance it may give an IPv6 address while IPv6 doesn't work. The correct solution is to use getent ahosts <host> to try both IPv6
Пробывал такие варианты, но все они возращали результаты самого сервера: 1. SYS_CONTEXT ( 'CLIENTCONTEXT', 'IP_ADDRESS' ) 2. SYS_CONTEXT ( 'USERENV', 'IP_ADDRESS' ) 3. utl_inaddr.get_host_address(). Как вставить IP средствами СУБД Oracle 10g?
I still get the ORA-24247: network access denied by access control list (ACL). Because I did everything else as suggested, I am starting to think that the problem could be that first configuration file which I added, but cannot remove now because I cannot remember its name.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters.
Making HTTP requests from PL/SQL is fairly simple, using the supplied package UTL_HTTP.
awk command is powerful, learn how to read from a file, use data fields, built-in variables, data variables, formatted printing and built-in functions.
First confirm this host exists from a command prompt