Handling exceptions from table columns values and emailing ASAP Please

From: <clinttoris_at_hotmail.com>
Date: 27 Jul 2006 09:52:57 -0700
Message-ID: <1154019177.796611.262880@h48g2000cwc.googlegroups.com>

Howdie,

I am using Oracle 9 and UTL_SMTP pacakge.

Could someone please help me with my code. I have a database table with lets just say 2 colums EAddress and CC. In these fields are email addresses that I have populated manually using the Insert into tableX Values('jsheco_at_hotmail.com', 'goracle_at_yahoo.ca').

If any one of the email address are invalid I need my exception handler to send me an email telling me the email address that caused a problem as well as the error message and not send out the message to the EAdress or CC. My exception handler is inside a loop so it will do this for all rows. Here is my stab at the code. If anyone could help me code this much appreciated.

 EXCEPTION

         WHEN utl_smtp.transient_error OR utl_smtp.permanent_error THEN
         UTL_SMTP.MAIL(mail_conn, 'MrAdmin_at_yahoo.ca');
        raise_application_error(-20000, 'Failed to send mail due to the
following error: ' || sqlerrm);
         END;

    END LOOP; Thanks for looking at this. Received on Thu Jul 27 2006 - 11:52:57 CDT