This discussion is archived
1 Reply Latest reply: Jan 22, 2013 1:00 PM by Mahmoud_Rabie RSS

APEX_MAIL_QUEUE question (APEX 2.2.0)

600949 Newbie
Currently Being Moderated
Hi, all,

Is there a way to tell which e-mails were generated by my application (or schema) in the APEX_MAIL_QUEUE table?

  • 1. Re: APEX_MAIL_QUEUE question (APEX 2.2.0)
    Mahmoud_Rabie Journeyer
    Currently Being Moderated
    Dear Don
    Oracle Application Express stores unsent email messages in a table named APEX_MAIL_QUEUE. You can manually deliver mail messages stored in this queue to the specified SMTP gateway by invoking the APEX_MAIL.PUSH_QUEUE procedure.
    Oracle Application Express logs successfully submitted message in the table APEX_MAIL_LOG with the timestamp reflecting your server's local time. Keep in mind, the most efficient approach to sending email is to create a background job (using a DBMS_JOB package) to periodically send all mail messages stored in the active mail queue.
    Please check the reference

    If this solves your question, please, mark it as correct otherwise as helpful