oracle 11G utl_mail 自动发邮件

最新推荐文章于 2021-04-13 15:47:11 发布

quanhj

最新推荐文章于 2021-04-13 15:47:11 发布

阅读量4.2k

点赞数

本文链接：https://blog.csdn.net/quanhj/article/details/8651272

版权

UTL_MAIL 是Oracle提供的用于管理和发送电子邮件的包，支持附件、抄送和密送等特性。由于安全考虑，默认未安装。使用前需配置SMTP参数，并确保用户有连接远程主机的权限。该包包含SEND、SEND_ATTACH_RAW和SEND_ATTACH_VARCHAR2等子程序，方便快捷地发送邮件。

摘要由CSDN通过智能技术生成

UTL_MAIL

The UTL_MAIL package is a utility for managing email which includes commonly used email features, such as attachments, CC, and BCC.

This chapter contains the following topics:

Using UTL_MAIL
- Security Model
- Operational Notes
- Rules and Limits
Summary of UTL_MAIL Subprograms

Using UTL_MAIL

Security Model

UTL_MAIL is not installed by default because of the SMTP_OUT_SERVER configuration requirement and the security exposure this involves. In installing UTL_MAIL, you should take steps to prevent the port defined by SMTP_OUT_SERVER being swamped by data transmissions.

This package is now an invoker's rights package and the invoking user will need the connect privilege granted in the access control list assigned to the remote network host to which he wants to connect.

Note:

For more information, see Managing Fine-grained Access to External Network Services in Oracle Database Security Guide

Operational Notes

You must both install UTL_MAIL and define the SMTP_OUT_SERVER.

To install UTL_MAIL:

sqlplus sys/<pwd>
SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb

You define the SMTP_OUT_SERVER parameter in the init.ora rdbms initialization file. However, if SMTP_OUT_SERVER is not defined, this invokes a default of DB_DOMAIN which is guaranteed to be defined to perform appropriately.

Rules and Limits

Use UTL_MAIL only within the context of the ASCII (American Standard Code for Information Interchange) and EBCDIC (Extended Binary-Coded Decimal Interchange Code) codes.