Re: Oracle Email Procedure
Date: Tue, 22 Oct 2002 20:25:08 GMT
Message-ID: <Euit9.58270$md1.10376_at_sccrnsc03>
Bob,
Here is a PL/SQL procedure which implements emailing from the database:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_example_repcheck_no _mdef1.html
I use this procedure to monitor Advanced Replication, but of course the basic concepts are the same regardless of what you want to email.
David Simpson
www.dotcomsolutionsinc.net
(Oracle Replication Consulting & Tools)
"Bob" <bobs_at_yahoo.com> wrote in message
news:hY1t9.581495$f05.24399180_at_news1.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 :-)
>
>
>
Received on Tue Oct 22 2002 - 22:25:08 CEST