Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle apex Emails not getting delivered

Rakesh119Sep 16 2022

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
image.png
prod apex administration email settings
image.png
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   => 'no-reply@aaa.com',
    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;
This post has been answered by Rakesh119 on Sep 16 2022
Jump to Answer
Comments
Post Details
Added on Sep 16 2022
13 comments
1,862 views