FAQ
Hi All,

I am using below code to send mail to Lotus Notes. It works fine except
when I receive a mail message the time stamp is correct. However when
I open the mail message the time stamp in the header is 4 hours off. It
must have something to do with
utl_smtp.write_data(connection, header);

Does anyone have any suggestions on what to check?
It is definitely related to Oracle config because if I change below code
from
header:= 'Date: '||TO_CHAR(SYSDATE,'dd Mon yy hh24:mi:ss')||crlf|| TO
header:= 'Date: '||TO_CHAR(SYSDATE + 1/6,'dd Mon yy hh24:mi:ss')||crlf||
the time is correct in the mail header.

Thanks
Rick

PROCEDURE mail
(

sender IN VARCHAR2,
recipient IN VARCHAR2,
ccrecipient IN VARCHAR2,
subject IN VARCHAR2,
message IN VARCHAR2

) IS

crlf VARCHAR2(2):= UTL_TCP.CRLF;
connection utl_smtp.connection;
mailhost VARCHAR2(30) := 'my_mailhost';
header VARCHAR2(1000);
status VARCHAR2(300);

BEGIN

--

Start the connection.
--
connection := utl_smtp.open_connection(mailhost,25);

header:= 'Date: '||TO_CHAR(SYSDATE,'dd Mon yy hh24:mi:ss')||crlf||

'From: '||sender||''||crlf||
'Subject: '||subject||crlf||
'To: '||recipient||crlf||
'CC: '||ccrecipient;

--

Handshake with the SMTP server
--
utl_smtp.helo(connection, mailhost);
utl_smtp.mail(connection, sender);
utl_smtp.rcpt(connection, recipient);
IF TRIM(ccrecipient) IS NOT NULL THEN
utl_smtp.rcpt(connection, ccrecipient);
END IF;

utl_smtp.open_data(connection);
--
Write the header
--
utl_smtp.write_data(connection, header);
--
The crlf is required to distinguish that what comes next is not simply
part of the header..
--
utl_smtp.write_data(connection, crlf||crlf ||message);
utl_smtp.close_data(connection);
utl_smtp.quit(connection);

END mail;

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Rick_Cale_at_teamhealth.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 29, '03 at 8:04p
activeAug 29, '03 at 8:04p
posts1
users1
websiteoracle.com

1 user in discussion

Rick_Cale_at_teamhealth.com: 1 post

People

Translate

site design / logo © 2022 Grokbase