How To Install Dbms_Network_Acl_Admin Package

Access to network resources is now controlled through ACL’s (Access Control Lists). In Oracle database 11g, access to external network resources has been more restricted than in previous versions.

P_sender => => => ‘This is the subject line!’,Įnvironment: APEX 4.1.1, Oracle database 11.2.0.3.0, Oracle Linux 6.2 Without an ACL, you will receive the following error: “ ORA-24247: network access denied by access control list (ACL)“.ĭescription => 'Permissions to access e-mail server.',Īfter these steps, you should be able to successfully send e-mails from within the database: SQL> alter system set smtp_out_server = scope=both įinally, you need to create an Access Control List (ACL) for your e-mail server and grant the necessary users access to this ACL. If you do not do this, you will receive a “ ORA-06502: PL/SQL: numeric or value error” error when you try to use the UTL_MAIL package.Įxecute the following with user SYS as SYSDBA: Next, you need to add the address and port of the e-mail server to the “ smtp_out_server” initialization parameter. SQL> grant execute on utl_mail to public

To get this procedure working on Oracle 11g, there are several steps you need to take.įirst, you need to actually install the UTL_MAIL package. P_mime_type IN VARCHAR2 DEFAULT 'text/plain charset=us-ascii' Suppose that you created the following wrapper procedure in PL/SQL:ĬREATE OR REPLACE PROCEDURE UTILS.SEND_MAIL ( Sending e-mails from within the Oracle database using the UTL_MAIL PL/SQL package used to be quite easy in Oracle 10g. However, in Oracle 11gR2, things have changed.

Environment: Oracle database 11.2.0.3.0, Oracle Linux 6.2

How To Install Dbms_Network_Acl_Admin Package