Sending Mail with Multiple Attachment In PL/Sql

Aykut Akın's Blog

Oracle provides you two different packages for sending mail. Utl_Smtp package firstly introduced in Oracle 8i and Utl_Mail package firstly introduced in Oracle 10g. In my post, I will give example with Utl_Smtp package.

First of all you need to understand ‘MIME Type’ concept for my example. I will explain it briefly, but you can find more detail in here. We will use MIME standart for creating multiple part e-mail.

We will use common header MIME informations like To, Date, From etc. to standartize our email content. Boundry feature will be used for creating multi attachment mail. Every attachment will be divided by a boundry and every attachment will have its own content type and name. With content type parameter, you can specify text/plain, text/html etc. types. If your content type is set to text/html, you can use html tags like table, tr, br etc. and with this way…

View original post 547 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s