Home » SQL & PL/SQL » SQL & PL/SQL » sending email or not (Oracle 11g)
sending email or not [message #568495] Fri, 12 October 2012 07:36 Go to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Hi All,

Using the procedure i am sending the emails..how can find the end user received or not?
Do you have any packages to verify the email successfully received or not?

Thanks,
Re: sending email or not [message #568496 is a reply to message #568495] Fri, 12 October 2012 07:44 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: sending email or not [message #568498 is a reply to message #568496] Fri, 12 October 2012 07:52 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Thanks Micheal...Do you have any idea how can achieve other than oracle/
Re: sending email or not [message #568501 is a reply to message #568498] Fri, 12 October 2012 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way.
No way in Oracle, no way in Unix, no way in Windows.
This does not depend on your local system.
If you send me a mail you will never know if I get it or not, anyway you'll send it.

Regards
Michel
Re: sending email or not [message #568504 is a reply to message #568498] Fri, 12 October 2012 08:33 Go to previous messageGo to next message
Solomon Yakobson
Messages: 2028
Registered: January 2010
Senior Member
If recipient email address doesn't exist most mail servers send "mail delivery6 system error" emails back to sender. Also, sender can use tracking options: request delivery receipt and/or request read receipt. Obviously all of the above come asinchronously, so you can't tell immediately if email was delivered.

SY.
Re: sending email or not [message #568505 is a reply to message #568504] Fri, 12 October 2012 08:38 Go to previous message
Michel Cadot
Messages: 59142
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
(My provider do not send any answer to not easy the spam robots work.) Anyway you cannot do it in PL/SQL as you have no way to receive something from a mail server as you have no address or mail box.
Of course, if you use your valid mailbox (private or professional) then you will receive the notification in it but this is not your database user that receives it but you as a real person.

Regards
Michel
Previous Topic: How to insert value in column which has date datatype?
Next Topic: After servererror on database
Goto Forum:
  


Current Time: Fri Sep 19 05:14:54 CDT 2014

Total time taken to generate the page: 0.08523 seconds