ATT_FILENAME VARCHAR2 IN DEFAULT创建存放附件的目录.
create directory export as '/oracle/product/dump_dir';
grant read,write on directory export to public;没有附件的邮件发送示例:
END;
/oracle在send_attach_varchar2中附件内容用varchar2来存储,也就是说附件不能大于32k.send_attach_raw不能发送超过2000字节的附件.
有关oracle发送mail的信息可以参考,metalink:Doc ID:269375.1 Doc ID:201639.1 FAQ and Known Issues While Using UTL_SMTP and UTL_MAIL Doc:ID 730746.1 其中包含了发送大于32k附件的方法