Re: Oracle Email Procedure

From: Hilary Band <hband_at_csc.com>
Date: 22 Oct 2002 08:30:22 -0700
Message-ID: <5b489863.0210220730.6d49cc7a@posting.google.com>

"Bob" <bobs_at_yahoo.com> wrote in message news:<1m2t9.549845$v53.23263581_at_news3.calgary.shaw.ca>...
> When using the UTL_SMTP.Write_Data command, is there a trick to getting text
> into the body of a message. I am able to run a proc that will sucessfully
> send an eMail message to the right place with the correct subject text but
> nothing in the body. I have defined a short 25-30 character string as the
> message but the message arrives with a blank body. Any suggestions? Thanks.
>
> Bob :-)

Hi Bob

We have implemented a package using UTL_SMTP which works successfully. We pass the body of the message into the procedure as a parameter, along with the To address, From address and Subject. Within the procedure we concatenate all these parameters, including the message body, into one string. We then use UTL_SMTP.WRITE_DATA to send the string to the mail host.

The procedure is based on the example which you can find on Metalink.

HTH H Received on Tue Oct 22 2002 - 10:30:22 CDT