Posts

Showing posts from January, 2019

UTL_SMTP: Send an Email to Multiple Recipients with Attachments from Oracle PL/SQL

Image
Here i am giving an example to send an email to multiple recipients with attachments from Oracle PL/SQL. I took this as challenge and done this for my client. Note: Blob (file) Stored in Oracle Directory. Explanation: The UTL_SMTP package was introduced in Oracle 8i and can be used to send emails from PL/SQL. Email with Attachments: Attaching a BLOB requires the binary data to be encoded and converted to text so it can be sent using  UTL_SMTP . Multiple Recipients: When dealing with multiple recipients, the UTL_SMTP.RCPT procedure needs to be called for each recipient, whether they are a "TO", "CC" or "BCC". The distinction between the types of recipient is made in the descriptions in the WRITE_DATA calls. The following procedure accepts comma separated "TO", "CC" and "BCC" parameters. The "TO" is mandatory, but the others are optional. If present, they are processed appropriately by splitting th