Mail within Oracle Database.

UTL_SMTP package is dedicated for sending email over SMTP. With this package it is quite easy to send e-mail to a specified user. It is easy to include a body of the message within email message body. But my requirement was, from a database table row will be retrieved and that row after analyze will be mailed to a user. It was not so easy for me and it sucked me significant time to do this. It was because body message is formatted by MIME(RFC822) specification. When a row is retrieved and I mailed that row I got a blank mail in my message body.The DATA routine will terminate the message with a . sequence (a single period at the beginning of a line), as required by RFC821. And every time I send mail at the first line it is terminated. It will also translate any sequence of . (single period) in body to .. (double period). So,I added with the message body UTL_TCP.CRLF

Then everything went ok.