Re: Oracle Java Question

HansF wrote:

> Greatest curiosity ... Oracle supplies the UTL_SMTP PL/SQL package (at no
> added charge) to handle mail from the database ...
>
> Is there something wrong with the package that it doesn't suit your needs?

UTL_SMTP is pretty low level and it is not easy to do things like attachments.

>From Ask Tom

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:255615160805

<quote>
The UTL_SMTP package is best suited for sending small, text only emails from the database. While its API supports the sending of attachments and everything else it is left to you to actually encode the multi-part document for example turning binary attachments into mime-encoded documents.
</quote>

<quote>
That would be (conservatively) a couple of hundred, if not thousands of lines of PL/SQL code. Rather then do that, I will suggest that you use the already written and very robust JavaMail API as described below.
</quote>

-- 
MJB