I'm using apex version 4.1.0.00.32 on 11gr2 Oracle database. When sending emails using the apex_mail package I get no errors, but emails are 'stuck' in the apex_mail_queue. It takes about 2 -to- 3 hours to actually receive the intended email. Originally I thought this could be ACL or SMTP related error, but don't think so. I tried issuing the below commands after the apex_mail.send call, but is no help.
The emails are eventually delivered but there seems to be a lag time. This happens Only on one of the Databases instances and works fine on a different instance. I have compared Instance Settings between these two databases and can't notice anything. Can't really figure out why ?
p_to => 'firstname.lastname@example.org',
p_from => 'email@example.com',
p_body => 'Send email from Apex',
p_body_html => 'Send email from Apex',
p_subj => 'Send email from Apex',
p_cc => '',
p_bcc => ''
Anyone any ideas?
I have commented out the call to PUSH_QUEUE_BACKGROUND, but problem still exists.
Emails are sent when I run the UTL_SMTP package, but not with APEX_MAIL package. I was assuming APEX_MAIL is just a wrapper around UTL_SMTP Package but it doesn't appear to be the case. As a result all our IR report subscriptions are stuck in the Mail queue and not being delivered at all. As I've mentioned before the issue is Only with one of the Database instances, it works fine in other but I've the problem just with one instance.
I verified all the Instance settings logging in as Apex Administrator but really can't figure out what the issue here is. Appreciate any help !!