utl_smtp email delivery time stamp problem...
302996Oct 18 2002 — edited Feb 28 2005Hi,
We have a stored procedure to send emails from database and we are using UTL_SMTP for same. We are facing problems with the emails which are sent out of our system.
Problems :-
1.) Emails reach to the user after certain time delay (sometimes 4-5 hrs).
2.) Sometimes the time stamp on the email is wrong. Say my system generated an email at 1.22PM and I received it on 1.25 PM. But when I open the message, it shows the time stamp as 9.53AM.
How is this happening ?
Few Questions :-
1.) Is there any queue on the database side for email message ? And the message are getting queued there ?
2.) What date time stamp the email takes ? Is it the database or the Unix server on which the instance is running or Is it the Email server?
3.) Does UTL_SMTP uses Java Mail on the server ?
If we know how exactly this UTL_SMTP packgage works internally and sends email, it will help us solving the issue.
For our system to work efficiently, timely delivery of email is very necessary.
Thanks