Email Notification Configuration

-- Connect Sys user and execute following
GRANT EXECUTE ON UTL_HTTP to SMARTHCM_SADAD;
GRANT EXECUTE ON UTL_TCP to SMARTHCM_SADAD;
GRANT EXECUTE ON UTL_SMTP to SMARTHCM_SADAD;
GRANT EXECUTE ON UTL_INADDR to SMARTHCM_SADAD;
 
begin
  dbms_network_acl_admin.create_acl (
    acl         => 'SendEmailService.xml',
    description => 'Send Email via Webservice',
    principal   => 'SMARTHCM_SADAD',
    is_grant    => TRUE,
    privilege   => 'connect'
    );
    commit;
end;
/

begin
  dbms_network_acl_admin.add_privilege (
  acl       => 'SendEmailService.xml',
  principal => 'SMARTHCM_SADAD',
  is_grant  => TRUE,
  privilege => 'resolve'
  );
  commit;
end;
/

begin
  dbms_network_acl_admin.assign_acl(
  acl  => 'SendEmailService.xml',
  host => 'sadad.smarthcm.com'
  );
  commit;
end;
/

-- Test it
begin
  -- Call the procedure
  set_send_email_pkg.send_email_via_wc('smtp.gmail.com',
                                       '587',
                                       'sadad.smarthcm.com@gmail.com',
                                       'usman@sofdigital.com',
                                       'Testing Email Subject',
                                       'Testing Email Body Message');
end;


-- To verify the above script is successfully executed 
SELECT * FROM dba_network_acl_privileges;
SELECT * FROM dba_network_acls; 

Note:

• Where “host” is the IP of the Email Server (‘*’ means auto find the specific email server)
• Where “principal” is the Schema / Database Username where import the database