ORACLE 11G stored procedure send mail (Job), ORA-24247: Network access is denied by Access control List (ACL)

ORA-24247: Network access is denied by Access control List (ACL)

You need to use Dbms_network_acl_admin first. CREATE_ACL Create an Access control List (ACL),
Then use the dbms_network_acl_admin. Assign_acl This ACL is associated with the mail server,
Finally, use Dbms_network_acl_admin. Add_privilege This ACL grants the user permission to connect to the mail server.

BEGIN
Dbms_network_acl_admin. Create_acl (
ACL = ' Email_server_permissions.xml ',
Description = ' Enables network permissions for the e-mail server ',
Principal = ' SMP ',
Is_grant = TRUE,
privilege = ' Connect ');
END;
/

BEGIN
Dbms_network_acl_admin.assign_acl (
ACL = ' Email_server_permissions.xml ',
host = '[email protected]',

Lower_port = 25,
Upper_port = NULL);
COMMIT;
END;
/

--drop
BEGIN
Dbms_network_acl_admin.drop_acl (ACL = ' email_server_permissions.xml ');
COMMIT;
END;
/

--Query
SELECT host, Lower_port, Upper_port, ACL from DBA_NETWORK_ACLS;

SELECT Acl,principal,privilege,is_grant,to_char (start_date, ' dd-mon-yyyy ') as Start_date,to_char (End_date, ' Dd-mon-yyyy ') as End_date
From Dba_network_acl_privileges;

ORACLE 11G stored procedure send mail (Job), ORA-24247: Network access is denied by Access control List (ACL)