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?

Thanks!
  • 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
    http://docs.oracle.com/cd/E14373_01/apirefs.32/e13369/apex_mail.htm

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

    Regards
    Mahmoud