Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_mail002.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>PUSH_QUEUE Procedure</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:16Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="PUSH_QUEUE Procedure" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12510-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="apex_mail.htm" title="APEX_MAIL" type="text/html" /> <link rel="up" href="apex_mail002.htm" title="PUSH_QUEUE Procedure" type="text/html" /> <link rel="prev" href="apex_mail001.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_mail003.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="apex_mail.htm" title="APEX_MAIL">APEX_MAIL</a> > PUSH_QUEUE Procedure</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="apex_mail001.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_mail003.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDJGGHG" name="CHDJGGHG"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI344" id="AEAPI344"></a>PUSH_QUEUE <a id="sthref501" name="sthref501"></a><a id="sthref502" name="sthref502"></a><a id="sthref503" name="sthref503"></a><a id="sthref504" name="sthref504"></a>Procedure</h1> <p>Oracle Application Express stores unsent email messages in a table named <code>APEX_MAIL_QUEUE</code>. You can manually deliver mail messages stored in this queue to the specified SMTP gateway by invoking the <code>APEX_MAIL.PUSH_QUEUE</code> procedure.</p> <p>Oracle Application Express logs successfully submitted message in the table <code>APEX_MAIL_LOG</code> 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 <code>DBMS_JOB</code> package) to periodically send all mail messages stored in the active mail queue.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="../aadm_email.htm">"Sending an Email from an Application"</a> in <a href="../preface.htm"><span class="italic">Oracle Application Express Application Builder User's Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="sthref505" name="sthref505"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_MAIL.PUSH_QUEUE( p_smtp_hostname IN VARCHAR2 DEFAULT NULL, p_smtp_portno IN NUMBER DEFAULT NULL); </pre> <a id="sthref506" name="sthref506"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDFCBBJ">Table: PUSH_QUEUE Parameters</a> describes the parameters available in the <code>PUSH_QUEUE</code> procedure.</p> <div class="tblformal"><a id="sthref507" name="sthref507"></a><a id="CHDFCBBJ" name="CHDFCBBJ"></a> <p class="titleintable">PUSH_QUEUE Parameters</p> <table class="Formal" title="PUSH_QUEUE Parameters" summary="This table describes the parameters available in PUSH_QUEUE." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t7">Parameters</th> <th align="left" valign="bottom" id="r1c2-t7">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t7" headers="r1c1-t7"> <p><code>p_smtp_hostname</code></p> </td> <td align="left" headers="r2c1-t7 r1c2-t7"> <p>SMTP gateway host name</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t7" headers="r1c1-t7"> <p><code>p_smtp_portno</code></p> </td> <td align="left" headers="r3c1-t7 r1c2-t7"> <p>SMTP gateway port number</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <p>Note that these parameter values are provided for backward compatibility, but their respective values are ignored. The SMTP gateway hostname and SMTP gateway port number are exclusively derived from values entered on the Manage Environment Settings when sending email.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="../AEADM/adm_env.htm">"Configuring Email Settings"</a> in <a href="../AEADM/preface.htm"><span class="italic">Oracle Application Express Administration Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> <a id="sthref508" name="sthref508"></a> <p class="subhead2">Example</p> <p>The following example demonstrates the use of the <code>APEX_MAIL.PUSH_QUEUE</code> procedure using a shell script. This example only applies to UNIX/LINUX installations.</p> <pre xml:space="preserve" class="oac_no_warn"> SQLPLUS / <<EOF APEX_MAIL.PUSH_QUEUE; DISCONNECT EXIT EOF </pre> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="../aadm_email.htm">"Sending Email from an Application"</a> in <a><span class="italic">Oracle Application Express Application Builder User's Guide</span></a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="refsect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="apex_mail001.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_mail003.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de