Send email not working in Oracle Free tier APEX Instance?

Kinjan Bhavsar

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        => '[email protected]',
               p_to          => '[email protected]',
               p_template_static_id => 'ORDER',
               p_placeholders    => l_placeholders);
          
  apex_mail.push_queue;

Screenshot from the mail queue

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?

InoL

The free tier doesn't have email. That "one blog" probably describes how to set it up when you have a paid account, or you are still in the trial period with $300 credit.

Kinjan Bhavsar

Hi @InoL ,

Is there a workaround to use this or I need to install the same application in apex.oracle.com and try sending email?

InoL

The workaround is to switch to a paid account. If you don't use any of the other paid features, email is very cheap. If I remember correctly $0.01 per 1000 emails.

For demo purposes only, you can try email on apex.oracle.com.

Kinjan Bhavsar

Thanks @InoL .

Could you please suggest the second issue related to permissions? I exported the application from one instance and tried to install it in the 2nd instance but it's giving a security error.

InoL

Exporting an application does not export any related data. Maybe that is your problem? Login as ADMIN and double check.

Kinjan Bhavsar

Thanks @InoL

I have few more questions regarding emails, if I install db machine and apex on localhost in my windows system using the built in VirtualBox that oracle is providing for developers, will I be able to send emails using APEX_MAIL.SEND and will I be able to configure personal SMTP details?

AndyH

https://community.oracle.com/tech/developers/discussion/comment/16846583#Comment_16846583

You can send emails this way.

You would need to tell Oracle APEX installation which SMTP server, username, password etc. to use and may involve downloading certificates to a wallet.