Error occurs when sending email from database 11g triiger
We had 9i database and we migrated to 11g. one of the problems that occurred was executing the "demo_mail" package that sends emails. The problem Sending mail via UTL_TCP and UTL_SMTP failes ERROR at line 1: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP" , line 17 ORA-06512: at "SYS.UTL_TCP" , line 246 ORA-06512: at "SYS.UTL_SMTP" , line 115 Cause : The Database user which execute the demo_mail package is not authorized to open connection and send a mail. Solution : suppose that the user executes the package is "Scott" and smtp_host is " email2.dhaman.org" SQL> EXECUTE DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'send_mail.xml',description => 'send_mail ACL',principal => 'scott',is_grant => true,privilege => 'connect'); PL/SQL procedure successfully completed. SQL> EXECUTE DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl ...