1 Reply Latest reply: Jan 22, 2013 3:00 PM by Mahmoud_Rabie RSS

    APEX_MAIL_QUEUE question (APEX 2.2.0)

      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)
          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