UTL_SMTP package for sending emails
On the otn forum, I have seen a number of posts about users trying to send emails from the database. For those that don’t know it yet, there is the utl_smtp package that can be used for this purpose.
Setup is very easy and usage is quite straightforward. Either use a procedure or a function and make use of the basic commands (smtp connection, message setup, message sending and smtp deconnect). If you need to send UTF characters, you will have to use the raw command.
For further info, check:
www.oracle.com/technology/sample_code/
www.psoug.org/reference/utl_smtp.html
www.ss64.com/orap/UTL_SMTP.html
Similar Posts:
- Why you need to worry about NLS_DATE_FORMAT !
- Java with Oracle Forms 10g- Sending SMS messages
- What about a Development tool à la Lotus Designer
- Solving the Oracle Reports 10g fonts problem
- WebUtil to the rescue: how to maintain client-side functionalities.
