How to send e-mail in PL/SQL 1

[request]

I have Oracle 8i version. I have to code a stored procedure in which I have to send an-email to certain people whether the procedure fails or succeeds. How can I do it?

Please help. Any assistance will be greatly appreciated.

thanks.

 

[sem]

Use UTL_SMTP package.

Regards, Dima

 

[KC6]

But is HTML mail possible using this proc?

 

[sem]

What do you mean by HTML mail?

Regards, Dima

 

[lecorr]

This code is available in the thread named 'Oracle release 8 and 8i'. Just search for email and you'll find the code to send a mail from the database itself or from a form.

Regards,

Christian