This forum is currently locked. You can't register or post questions at this time. (read more)

send mail using oracle 9i

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Guest

send mail using oracle 9i

Postby Guest » Mon Nov 01, 2004 6:09 pm

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE: send mail using oracle 9i

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Guest

RE: send mail using oracle 9i

Postby Guest » Mon Nov 01, 2004 6:09 pm

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

RE: send mail using oracle 9i

Postby Tim... » Mon Nov 01, 2004 6:09 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 2 guests

cron