Re: UTL_SMTP Multiple emails on same connection (not multiple recipients)
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: David Robillard <david.robillard@xxxxxxxxx>
- Date: Wed, 1 Sep 2010 08:00:05 -0700
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:
