Re: help with utl_smtp email headers

On 19 Aug 2003 06:05:33 -0700, Tracey <tracey.lemer_at_itsservices.com> wrote:

> 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/