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!

Send email not working in Oracle Free tier APEX Instance?

Kinjan BhavsarAug 27 2022

Hi,
I have set up a free APEX Instance on Oracle Cloud and everything worked fine. I created a new application, a few forms, few reports but then when I am trying to send an email, it's not working. I am using a simple send email logic as below

apex_mail.send(p_from        => 'test123@gmail.com',
               p_to          => 'test234@gmail.com',
               p_template_static_id => 'ORDER',
               p_placeholders    => l_placeholders);
          
  apex_mail.push_queue;

Screenshot from the mail queue
image.png
I only created APEX instance nothing else, then I found one blog from an oracle that explained how to get and configured SMTP credentials so I tried to create an autonomous database with an APEX instance, and in that when I imported the application from my other APEX instance, it's not allowing me to open and giving me permission error. Could someone help me with the above issue and this permission issue?

image.png

Comments
Post Details
Added on Aug 27 2022
7 comments
921 views