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

    APEX_MAIL_QUEUE question (APEX 2.2.0)

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