Forum Stats

  • 3,872,055 Users
  • 2,266,372 Discussions
  • 7,911,041 Comments

Discussions

oracle apex Emails not getting delivered

Rakesh119
Rakesh119 Member Posts: 117 Red Ribbon

I have go 2 apex environment

development

URL - https://peoemas-023.oc.aaa.com:8443/ords/APEXDEV/f?p=4550:1

Poduction

URL - https://peoemas-023.oc.aaa.com:8443/ords/APEXPRD/f?p=4550:1

I am using the same smtp hostname for both the environment and production

devlopment apex administration email settings


prod apex administration email settings


I am getting emails from application developed in development environment

But i am not getting emails from same application migrated to production.

The code to push email looks like this

 procedure sent_reset_email(
  p_email  in varchar2, pwd in varchar2)
  is
  l_body   clob;
  l_body_html clob;
  begin
    l_body := 'To view the content of this message, please use an HTML enabled mail client.';
    l_body_html := '<html><body>' ||
          '<p>Your Password has been reset</p>' ||
          '<p>Password:<strong>' || pwd || '</strong></p>' ||
          '<p>Please login and change your password on the <a href="' ||
          apex_mail.get_instance_url || 'f?p=100:9999">App tiltle</a> page.</p>' ||
          '</body></html>'; 

    apex_mail.send (
    p_to    => p_email,
    p_from   => '[email protected]',
    p_body   => l_body,
    p_body_html => l_body_html,
    p_subj   => 'Reset Password Email');

    apex_mail.push_queue;

  exception
  when others 
  then
  raise_application_error( - 20002, 'Issue sending reset password email.') ;
  end;


Tagged:

Best Answer

«1

Answers