Oracle/UTL_SMTP

Advertisement


Question
Hi,

How are you ?


I am using Oracle 11g and  UTL_SMTP package to send mail.
The problem which is I am having is that there are mail address in TO and CC.
IF any mail address is not valid then my mail will not go to the valid mail address.
Now can I do something like that my mail will go to the valid address even any one is invalid mail address?

I donít want to stop my mail

Please help me on this ASAP


Thanks,
Gaurav

Answer
Hello Gaurav,

You can try utl_Smtp in loop with a pl/sql block with exception handling, instead of adding all the addresses in TO field.

You can check the following link which might help -

https://community.oracle.com/thread/1125736?start=0&tstart=0


Regards

Suchitra

Oracle

All Answers


Answers by Expert:


Ask Experts

Volunteer


Suchitra Joshi

Expertise

I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.

Experience

15+ years of Oracle PL/SQL Development

Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)

Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000

©2016 About.com. All rights reserved.