Database Utilities (MOSC)

MOSC Banner

utl_smtp - invalid email - code fails - still want to send emails to rest of the people

edited Sep 6, 2010 7:41PM in Database Utilities (MOSC) 1 commentAnswered
  We are sending email notifications to all our employees using utl_smtp utility in pl/sql code. Let assume, we are sending email notifications to 1000 employees – which is going great.

Recently we faced a situation where few employees has wrong ( in-valid ) email address in Oracle HR tables. As soon as code ( utl_smtp) tries to send email to invalid address it fails – which is OK. But, code error out ( stop execution) at that point and does not send emails to next employees. We want to send emails to rest of the employees whose email addresses are valid though some of the employees has in-valid email address here & there.(Email validation is not possible for us because we have wide variety of formats).How can we accomplish this

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center