Re: help with utl_smtp email headers

[Ana C. Dent]

On 19 Aug 2003 06:05:33 -0700, Tracey <tr**********@itsservices.comwrote:

I have written a procedure to send email from oracle using examples
from everyone, but I don't understand how to fill in the from, to, and
subject fields in the email heading.

utl_smtp.write_data just puts the information in the body of the
email. How does one populate the fields that I have mentioned above? Am I
missing something?

Thank you for your help.

You need to conform to the SMTP "standard:

To: {recipent_name_here}
From: {sender}
Subject: {An_example}
Date: {yesterday}

this is the beginning of the actual message text.
SMTP "keywords" begin each Header line.
The message header is separated from the message body by the 1st blank
line.

HTH & YMMV

HAND!

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/