Sending an email alert to addresses in the database and getting a return email as notification

25 pts.
Tags:
PL/SQL
Stored Procedures
Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    I'm not sure what you are looking to get. If you are looking to see what is being sent out, why not just add your e-mail as a secondary e-mail address? Are you looking to have a copy of this in a database format?
    135,465 pointsBadges:
    report
  • ADagoseh
    I want to know if email send to a customer was successful.
    25 pointsBadges:
    report
  • ToddN2000
    Have you tried sending it through your e-mail server with a return receipt? This will let you know when they have read the e-mail. IF you are sending to an invalid e-mail address your server should kick back an error.
    135,465 pointsBadges:
    report
  • carlosdl
    PL/SQL has no way to know if the email was actually received by the addressee.

    The easiest way to see what was send is what Todd suggested in his first reply: Just add your e-mail address, so you get a copy of everything that is sent.  If you get your copy, it means that the message was actually sent (but it doesn't mean that it was actually received on the other end).
    85,430 pointsBadges:
    report
  • carlosdl
    Also, your PL/SQL code should have the necessary error handling code to tell you if the attempt to send the message failed.

    I'm still not clear about what you really want to do.
    85,430 pointsBadges:
    report
  • ADagoseh
    Thanks guys for your help, I am now up and you guys have shown me the way out.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: