Re: UTL_SMTP Multiple emails on same connection (not multiple recipients)

David,
thanks for your response.

I've seen lots of ways to send the same email to multiple people, but as
you've surmised from my pseudo code, what I want is different emails going
to different people. I am assuming that there is overhead on OPENING and
CLOSING the CONNECTION. So, I am trying to avoid doing the open/close for
each unique email. Maybe my assumption is wrong?

Mike



On Wed, Sep 1, 2010 at 4:31 AM, David Robillard
<david.robillard@xxxxxxxxx>wrote:

> Hello Michael,
>
> > Is there a way to send multiple/different emails without having to close
> and
> > re-open the connection for each email?
>
> Well, in your pseudo-code, amount due is not the same for all users,
> so you still need to have multiple lines of code with UTL_SMTP.
>
> But if that would not be the case, one easy way to do so is to create
> an alias in the server's SMTP configuration. Assuming you're running
> on UNIX or Linux, you can create an oracle alias in the server's
> /etc/mail/aliases file (or your mailhub if your machines are
> configured as null_clients) and then use that alias in your UTL_SMTP
> code.
>
> For example, if we use your previous pseudo-code, you could:
>
> sudo vi /etc/mail/aliases
>
> Add this new line:
>
> oracle: mm@xxxxxxxxx, fred@xxxxxxxxx
>
> Recreate the aliases.
>
> sudo newaliases
>
> Then use oracle@xxxxxxxxxxxxxx in your code.
>
> HTH,
>
> David
> --
> http://ca.linkedin.com/in/davidrobillard
>

Other related posts: