ul_smtp timestamp diffs

From: <whiskeydrainer_at_yahoo.com>
Date: 10 Feb 2004 08:47:06 -0800
Message-ID: <391104b4.0402100847.27acdc48@posting.google.com>

I have two stored procs, one "send_Files" and the other "send_message". I got most of the codes from these message boards.

I'd like to know why I get different timestamps on the emails and within the body on the send_files?

When files get sent using Send_File the timestamp on the email is hours earlier than the correct one within the email(from sysdate). And when I use Send_Message the timestamps agree on the email and inside the message.

There are differences in how the actual body of the message gets created open_data/write_data/close_data for the Send_File versus utl_smtp.data for the send_message, but no differences in how the email itself gets created (open_connection, helo, rcpt, quit).

The utl_smtp calls in Send_File include

conn := utl_smtp.open_connection (server_name, serverport);

utl_smtp.helo(conn, server_name);
utl_smtp.mail(conn, from_name);
utl_smtp.rcpt(conn, cc_name);

utl_smtp.open_data (conn);
utl_smtp.write_data(conn, message);
utl_smtp.close_data(conn);

utl_smtp.quit(conn);

The utl_smtp calls in Send_Message include

conn := utl_smtp.open_connection (server_name, serverport);

utl_smtp.helo(conn, server_name);
utl_smtp.mail(conn, from_name);
utl_smtp.rcpt(conn, cc_name);

utl_smtp.data(conn, message);

utl_smtp.quit(conn);

Any ideas would be aprreciated.

Thanks WD Received on Tue Feb 10 2004 - 10:47:06 CST