Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\ja\AEAPI\apex_mail003.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="ja" lang="ja"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>SEND?????????</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="SEND 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_mail003.htm" title="SEND Procedure" type="text/html" /> <link rel="prev" href="apex_mail002.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_item.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="?????">?????</a> > <a href="apex_mail.htm" title="APEX_MAIL">APEX_MAIL</a> > SEND?????????</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_mail002.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="apex_item.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</span></a></td> </tr> </table> <p><a id="CHDDAAJE" name="CHDDAAJE"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI342" id="AEAPI342"></a>SEND<a id="sthref511" name="sthref511"></a>?????????<a id="sthref509" name="sthref509"></a><a id="sthref510" name="sthref510"></a></h1> <p>???????????????????????????????????????°?????°????????????????????????????????????<code>VARCHAR2</code>?????<code>CLOB</code>??<code>p_body</code>?????<code>p_body_html</code>????????????????????????????????????????????????????<code>CLOB</code>??<code>P_BODY</code>????<code>VARCHAR2</code>??<code>p_body_html</code>???????????????????</p> <p><code>APEX_MAIL.SEND</code>?????????????????????????????????</p> <ul> <li> <p><span class="bold">1???1000???????????????????</span> SMTP/MIME???????????1???1000???????????????????????????????????????????????????????????????????????????????<code>p_body</code>?????<code>p_body_html</code>????°????1000??????????????????????????????????????????????????????????????????????????°????????????????????????????????????????????</p> </li> <li> <p><span class="bold">??????????????????HTML????°??????????????</span>???<code>p_body_html</code>??????<code>p_body</code>??????????????????????????????????????????????<code>p_body</code>?????<code>p_body_html</code>???????????????????????TML???????????????????????????????????????????????????¤???????°??????????????????????????????????????????????????????????????????°???????????????TML??????????????????????????????????????????????????????????????????????????????????????????????????????</p> </li> <li> <p><span class="bold">?????????????????????????</span><code><img /></code>???????????<code>p_body_html</code>????°?????????????????¤???????????????????????????¤???????°????????????????????°?????????????????????????????????????????</p> <p>??????????????????????????????<code>hello.gif</code>???????°?????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> <img src="http://someserver.com/hello.gif" alt="Hello" />] </pre> <p>????????????°????????°???????????????????????????????????????????????¤?????????????????????????eb???????????????????°?????????????????????????????°?????????????????????????????¤???????????????????????????????°???????????????????????????°???????????????????????°?????????????????????????°?????????????????????????????????????????????LT?????????????????????????</p> </li> </ul> <a id="sthref512" name="sthref512"></a> <p class="subhead2">???</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_MAIL.SEND( p_to IN VARCHAR2, p_from IN VARCHAR2, p_body IN [ VARCHAR2 | CLOB ], p_body_html IN [ VARCHAR2 | CLOB ] DEFAULT NULL, p_subj IN VARCHAR2 DEFAULT NULL, p_cc IN VARCHAR2 DEFAULT NULL, p_bcc IN VARCHAR2 DEFAULT NULL, p_replyto IN VARCHAR2); </pre> <a id="sthref513" name="sthref513"></a> <p class="subhead2">????°???</p> <p><a href="#CHDIIAFI">????END????°?????</a>????<code>SEND</code>??????????????????????°????????????</p> <div class="tblformal"><a id="sthref514" name="sthref514"></a><a id="CHDIIAFI" name="CHDIIAFI"></a> <p class="titleintable">SEND????°???</p> <table class="Formal" title="SEND????°???" summary="??????????END?????????????°??????????????????" 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-t10">????°???</th> <th align="left" valign="bottom" id="r1c2-t10">???</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t10" headers="r1c1-t10"> <p><code>p_to</code></p> </td> <td align="left" headers="r2c1-t10 r1c2-t10"> <p>????°????????????????????????????????????????????????????????????????????????????????????????????????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t10" headers="r1c1-t10"> <p><code>p_from</code></p> </td> <td align="left" headers="r3c1-t10 r1c2-t10"> <p>????°?????????????????°???????????????????????????????????????????????????????????????????????????????????????????????????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t10" headers="r1c1-t10"> <p><code>p_body</code></p> </td> <td align="left" headers="r4c1-t10 r1c2-t10"> <p>HTML????????????????????????????????????????????????????<code>p_body_html</code>???????????????¤????????????????????????????????<code>p_body_html</code>?????????????????????????????TML???????????????????°???????????????????HTML?????????????????????????????????????????????????????????????????????????????????????RLF???1000?????????????????????????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t10" headers="r1c1-t10"> <p><code>p_body_html</code></p> </td> <td align="left" headers="r5c1-t10 r1c2-t10"> <p>HTML?????????????????????????<code><html></code>????????<code><body></code>?????????????TML???????????????????????????????????????????????????????????RLF????????????????1???1000???????????????????????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t10" headers="r1c1-t10"> <p><code>p_subj</code></p> </td> <td align="left" headers="r6c1-t10 r1c2-t10"> <p>????°???????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t10" headers="r1c1-t10"> <p><code>p_cc</code></p> </td> <td align="left" headers="r7c1-t10 r1c2-t10"> <p>????°????????????????????????????????????????????????????????????????????????????????????????????????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t10" headers="r1c1-t10"> <p><code>p_bcc</code></p> </td> <td align="left" headers="r8c1-t10 r1c2-t10"> <p>????°?????????????????????????????????????????????????????????????????????????????????????????????????????????</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t10" headers="r1c1-t10"> <p><code>p_replyto</code></p> </td> <td align="left" headers="r9c1-t10 r1c2-t10"> <p>???????°????????????????????????????????????????°???????????</p> <ul> <li> <p><code>p_replyto</code>????°????????????????????????????????????<code>p_from</code>????°??????????????????????????</p> </li> <li> <p><code>p_replyto</code>????°????<code>NULL</code>??????????????????????????????????ULL???????????????????????????????????°????????????</p> </li> <li> <p><code>p_replyto</code>????°????NULL?????????????????????????????????????????????????????????????????????°??????????????????????????????????????°???????????????</p> </li> </ul> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref515" name="sthref515"></a> <p class="subhead2">??</p> <p>?°????????<code>APEX_MAIL.SEND</code>???????????????????????????????????????????????????????????????????????????</p> <pre xml:space="preserve" class="oac_no_warn"> -- Example One: Plain Text only message DECLARE l_body CLOB; BEGIN l_body := 'Thank you for your interest in the APEX_MAIL package.'||utl_tcp.crlf||utl_tcp.crlf; l_body := l_body ||' Sincerely,'||utl_tcp.crlf; l_body := l_body ||' The APEX Dev Team'||utl_tcp.crlf; apex_mail.send( p_to => 'some_user@somewhere.com', -- change to your email address p_from => 'some_sender@somewhere.com', -- change to a real senders email address p_body => l_body, p_subj => 'APEX_MAIL Package - Plain Text message'); END; / </pre> <p>?°????????<code>APEX_MAIL.SEND</code>???????????????????????TML???????????????????????????????????????????????????????????????????????????RLF???1000??????????????????????????????????<code>utl_tcp.crlf</code>???????????</p> <pre xml:space="preserve" class="oac_no_warn"> -- Example Two: Plain Text / HTML message DECLARE l_body CLOB; l_body_html CLOB; BEGIN l_body := 'To view the content of this message, please use an HTML enabled mail client.'||utl_tcp.crlf; l_body_html := '<html> <head> <style type="text/css"> body{font-family: Arial, Helvetica, sans-serif; font-size:10pt; margin:30px; background-color:#ffffff;} span.sig{font-style:italic; font-weight:bold; color:#811919;} </style> </head> <body>'||utl_tcp.crlf; l_body_html := l_body_html ||'<p>Thank you for your interest in the <strong>APEX_MAIL</strong> package.</p>'||utl_tcp.crlf; l_body_html := l_body_html ||' Sincerely,<br />'||utl_tcp.crlf; l_body_html := l_body_html ||' <span class="sig">The APEX Dev Team</span><br />'||utl_tcp.crlf; apex_mail.send( p_to => 'some_user@somewhere.com', -- change to your email address p_from => 'some_sender@somewhere.com', -- change to a real senders email address p_body => l_body, p_body_html => l_body_html, p_subj => 'APEX_MAIL Package - HTML formatted message'); END; / </pre></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 (C) 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"> <span class="copyrightlogo">???????????</span></a></td> <td align="center"><a href="apex_mail002.htm"><img src="../dcommon/gifs/leftnav.gif" alt="???" /><br /><span class="icon">???</span></a> </td> <td align="center"><a href="apex_item.htm"><img src="../dcommon/gifs/rightnav.gif" alt="?°?" /><br /><span class="icon">?°?</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