9 Replies Latest reply on May 18, 2012 10:04 AM by VC

Sending email from APEX is not working

917038 Apr 27, 2012 5:30 AM

Hi all,
I tried sending email using the inbuilt 'Send e-mail' process . Its showing success message , but I am not receiving any emails . What is the problem ?

Thanks & Regards
Umer

1. Re: Sending email from APEX is not working

917038 May 1, 2012 8:02 AM (in response to 917038)

Can someone help me ?
Like Show 0 Likes(0)

Actions
2. Re: Sending email from APEX is not working

VC May 1, 2012 8:41 AM (in response to 917038)

Nice1 wrote:
Hi all,
I tried sending email using the inbuilt 'Send e-mail' process . Its showing success message , but I am not receiving any emails . What is the problem ?

Thanks & Regards
Umer
Hi Umer,

Please answer some question in order to find the problem:

Have you configured the mail settings in Internal Workspace?

What did you chose for Send Immediately in the send-email process?

And finally try Apex_mail.push_queue to send the unsent emails

Thanks
Like Show 0 Likes(0)

Actions
3. Re: Sending email from APEX is not working

926190 May 1, 2012 8:56 AM (in response to 917038)

The above stated is correct, also you might want to check your webmails refresh interval (upon receiving inc mails).
It is not advised to spam mails from apex to your mail.
Like Show 0 Likes(0)

Actions
4. Re: Sending email from APEX is not working

917038 May 2, 2012 7:04 AM (in response to VC)

Have you configured the mail settings in Internal Workspace?

No, I don't know how to do that

What did you chose for Send Immediately in the send-email process?

yes , I have selected Send Immediately option

And finally try Apex_mail.push_queue to send the unsent emails

I dont know if there are mails in queue , how do I check it ?

I dont know about tApex_mail.push_queue
Like Show 0 Likes(0)

Actions
5. Re: Sending email from APEX is not working

VC May 2, 2012 12:00 PM (in response to 917038)

Hi Umer,

You need to configure the mail server under Internal Workspace > Instance settings first to get email work.

Please see http://docs.oracle.com/cd/E17556_01/doc/admin.40/e15521/adm_mg_service_set.htm#BEJBCEEH

Thanks
Like Show 0 Likes(0)

Actions
6. Re: Sending email from APEX is not working

917038 May 14, 2012 4:19 AM (in response to VC)

Thanks VC

I defined the setings . It shows "mail sent ",but it is pending in the mail queue , and is showing the following error message.
The error message is :
ORA-24247: network access denied by access control list (ACL)

I tried some methods from googling for solving this , but didnt work

Regards
Umer

Edited by: Nice1 on May 13, 2012 9:18 PM
Like Show 0 Likes(0)

Actions
7. Re: Sending email from APEX is not working

Jozef Demovic SVK May 14, 2012 7:29 AM (in response to 917038)

Hi,

This should help to you: http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/otn_install.htm#HTMIG508

Regards
J :D
Like Show 0 Likes(0)

Actions
8. Re: Sending email from APEX is not working

917038 May 18, 2012 9:26 AM (in response to Jozef Demovic SVK)

Is it possible to create a background thread which will send mail from APEX at predetermined time & date ?
Like Show 0 Likes(0)

Actions
9. Re: Sending email from APEX is not working

VC May 18, 2012 10:04 AM (in response to 917038)

Create an apex job to execute the APEX_MAIL.SEND API

http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21676/apex_plsql_job.htm#AEAPI353
1 person found this helpful
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.