How to Send Any Type of Attachment with UTL_MAIL
(Doc ID 946811.1)
Last updated on JULY 05, 2023
Applies to:
PL/SQL - Version 10.1.0.2 and laterInformation in this document applies to any platform.
Goal
To show you how to use the UTL_MAIL package to send any type of attachment:
- Text-Based
- Binary-Based
using one simple PL/SQL stored procedure.
While there are two procedures that can be used to send attachments
- UTL_MAIL.SEND_ATTACH_VARCHAR2
- UTL_MAIL.SEND_ATTACH_RAW
only one of them is truely needed as SEND_ATTACH_RAW can send both Text-Based and Binary-Based attachments and will be used in the sample code below.
Note: Before running this sample code UTL_MAIL must be properly configured. Refer to the PL/SQL Packages and Types Reference section on UTL_MAIL for more information on how to configure this package or contact your DBA for help.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |