Home » Developer & Programmer » Forms » Date problem in Email
Date problem in Email [message #255560] Wed, 01 August 2007 03:55 Go to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

I am using the following code to send emails from my application

PROCEDURE send_email
( sendernm IN VARCHAR2,
senderid IN VARCHAR2,
recipient IN VARCHAR2,
subject IN VARCHAR2,
message IN VARCHAR2,
mailsrvr IN VARCHAR2)
IS
host VARCHAR2(30) := mailsrvr;
mail_conn utl_smtp.connection;
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
msg VARCHAR2( 4000 );
BEGIN 
mail_conn := utl_smtp.open_connection(host, 25);
msg:= 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' ) || crlf ||
'From: '||sendernm||'<' ||senderid||'>' || crlf ||
'Subject: '||subject || crlf ||
'To: '||recipient || crlf ||
'' || crlf || message;
utl_smtp.helo(mail_conn, host);
utl_smtp.mail(mail_conn, senderid);
utl_smtp.rcpt(mail_conn, recipient); 
utl_smtp.data(mail_conn, msg);
utl_smtp.quit(mail_conn);
Exception
When others then
Null;
END;


Everything is working fine... except the Date... it is showing the wrong time on sent email.
./fa/2805/0/
  • Attachment: 1.jpg
    (Size: 55.61KB, Downloaded 206 times)
Re: Date problem in Email [message #256063 is a reply to message #255560] Thu, 02 August 2007 21:13 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please supply details of all the machines in your configuration. Where is the mail handler? Where is the database? Also operating systems and version of Forms and database.

David
Previous Topic: coding problem
Next Topic: How to populate Chart
Goto Forum:
  


Current Time: Sat Dec 10 16:26:00 CST 2016

Total time taken to generate the page: 0.07329 seconds