[原创申请精华]用oracle发送邮件（功能很全）

边-城 · 发表于 2013-3-27 13:39

benteke · 发表于 2013-3-28 12:05

好，有用

他山攻错 · 发表于 2013-4-24 15:12

chenzhoushiyu · 发表于 2013-4-26 08:06

exec PROCSENDEMAIL('中文测试邮件','中文主题','w.li@yydg.com.cn','w.li@yydg.com.cn','dgmail.yydg.com.cn',25,0,'','','D:/export.txt','bit 7');

命令的第 1 行開始發生錯誤:
exec PROCSENDEMAIL('中文测试邮件','中文主题','w.li@yydg.com.cn','w.li@yydg.com.cn','dgmail.yydg.com.cn',25,0,'','','D:/export.txt','bit 7')
錯誤報告:
ORA-01031: 權限不足
ORA-06512: 在 "AA.PROCSENDEMAIL", line 360
ORA-06512: 在 line 1
01031. 00000 -  "insufficient privileges"
*Cause: An attempt was made to change the current username or password
         without the appropriate privilege. This error also occurs if
         attempting to install a database without the necessary operating
         system privileges.
         When Trusted Oracle is configure in DBMS MAC, this error may occur
         if the user was granted the necessary privilege at a higher label
         than the current login.
*Action: Ask the database administrator to perform the operation or grant
         the required privileges.
         For Trusted Oracle users getting this error although granted the
         the appropriate privilege at a higher label, ask the database
         administrator to regrant the privilege at the appropriate label.

为什么我设置附件就会出现如上错误?

而不设置附件,可以发送成功,但是收件日期是 1970/1/1上午8:00