http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Packages%2FUTL_SMTP
Oracle PL/SQL/System Packages/UTL SMTP - История изменений
2026-05-24T11:41:20Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Packages/UTL_SMTP&diff=1288&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:19Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Packages/UTL_SMTP&diff=1289&oldid=prev
Admin: 1 версия
2010-05-26T09:55:24Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Use UTL_SMTP package to send out an email==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
DECLARE<br />
v_FromAddr VARCHAR2(50) := "Oracle";<br />
v_ToAddr VARCHAR2(50) := "YOUR_EMAIL_ADDRESS";<br />
v_Message VARCHAR2(200);<br />
<br />
v_MailHost VARCHAR2(50) := "localhost";<br />
v_MailConnection UTL_SMTP.Connection;<br />
BEGIN<br />
v_Message := <br />
"From: " || v_FromAddr || CHR(10) ||<br />
"Subject: Hello from PL/SQL!" || CHR(10) ||<br />
"message.";<br />
v_MailConnection := UTL_SMTP.OPEN_CONNECTION(v_MailHost);<br />
<br />
UTL_SMTP.HELO(v_MailConnection, v_MailHost);<br />
UTL_SMTP.MAIL(v_MailConnection, v_FromAddr);<br />
UTL_SMTP.RCPT(v_MailConnection, v_ToAddr);<br />
UTL_SMTP.DATA(v_MailConnection, v_Message);<br />
<br />
UTL_SMTP.QUIT(v_MailConnection);<br />
END;<br />
/<br />
<br />
--<br />
</source></div>
Admin