we send html emails using utl_smtp package to our customers. we want to track if the email was sent successfully without getting bounced. I was wondering if we can track this using utl_smtp package. can someone please let me know if we can do this by using UTL_SMTP package.
I don't think so. The errors from UTL_SMTP only tell you that the mailhost has rejected it (or was unavailable). Once the mailhost has the email, it may (according to the retry policy) attempt to send it over a very long period of time - your Oracle process may have gone away before it decides to give up. You will have to look for "undeliverble" messages sent by the mailhost to the "From:" address.