Re: utl_smtp

Mark wrote:

> Hello,
>
> I'm writing a procedure which uses utl_smtp to send various 4 Email messages
> to different recipients.
>
> What I'd like to do is to only send all 4 after they've been created
> successfully (i.e. no errors were encountered during the construction of the
> messages).
>
> I'm using utl_smtp.close_data at the end of each message to close the Email
> body and utl_smtp.quit at the end of my procedure to send the messages. What
> I'm after is, I suppose, a "rollback" equivalent of utl_smtp.quit which
> closes the connection to the mail server without actually sending messages
> which have been created. Is there such a thing?
>
> Thanks for any assistance.
>
> Mark

If in 10g use UTL_MAIL not UTL_SMTP. Otherwise ... just put your code into blocks and let the exception handler clean up the mess.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)