send mail using oracle 9i

[Guest]

how to use any application server & oracle 9i to send automatic scheduled emails

[Tim...]

Hi.

You don't need to use application server. You could do it all from within Oracle8i or Oracle9i.

You can use DBMS_JOB to schedule a batch job which calls a stored procedure. This procedure could produce all your emails and send them using UTL_SMTP.

Cheers

Tim...

[Guest]

Attachments are not supported, if email server is down, you simple miss your emails, some other deficiencies, not mentioning lots of coding required

[Tim...]

Hi.

1) True, attachments are not supported.

2) If you are worried about losing mails you should avoid SMTP and go for IMAP. All methods involving SMTP will not give an error if the mail cannot be sent.

3) I think UTL_SMTP requires the same amount of code as any other method I've used (JavaMail, ASPMail etc.) If you are looking for something with less code I think you're going to struggle. Check out my example of using UTL_SMTP:

http://www.oracle-base.com/articles/9i/ ... LSQL9i.php

Perhaps you should look into using JavaMail since this can be run from within the database or from your application server provided it's Java compliant:

http://java.sun.com/products/javamail/index.html

Cheers

Tim...