Link: Sending emails from the Oracle database can be both simply deceptively braindead easy, and confoundingly perplexingly awful at the same time.
Easy, because all you have to do is call one of the supplied mail packages to send an email: and interact directly with the mail server.
One day your server tries to send 100 emails to the same recipient in error, and all of a sudden your IP is blocked as a spammer and NO emails get sent, with no warning.
For the last two years I’ve been battling this problem, because my site allows my clients to broadcast messages to their customers and partners via email and SMS.
You’ll only be charged for messages actually sent, but they do require you to pay in advance – e.g.It’s up to you to either COMMIT or ROLLBACK, which determines whether the message is actually sent or not. You can have a message be scheduled at a particular point in time by setting the p_schedule_dt parameter.The default installation creates a job that runs every 5 minutes to push the queue.To check your account balance, call get_credit_balance.Please try it out if you can and let me know of any issues or suggestions for improvement.