Email Recipient List truncated

Rat 999 1 Reputation point
2020-09-19T16:48:42.087+00:00

When using plsql (utl_smtp or utl_mail) to send email thru exchange server with a list of recipients, the received email will show a truncated recipient list. Receivers that are truncated did confirm they receive the email fine. It seems that the email recipient list is truncated at around 254 to 260 ish characters. There was no special characters, not even a dash.

When email is sent directly from outlook with the same list of recipients, the Recipient list in the received email header is not truncated.

This just started happening lately. The program has been in use and not changed for quite some time. Because our company is running lots of update patches, I am wondering if there is configuration, setting limitation or security change that may have been changed.

Community Center | Not monitored
{count} votes

2 answers

Sort by: Most helpful
  1. Andy David - MVP 157.7K Reputation points MVP Volunteer Moderator
    2020-09-19T17:48:56.317+00:00

    I would ask Oracle support.

    If the emails to all the recipients are being delivered, then Exchange is handling it correctly.

    The recipients on the TO: header are supplied by the client connecting to Exchange and really represent nothing more than the display names of the recipients - and since that is the responsibility of the generating app, so I suspect the issue is on the plsql side, not Exchange.

    0 comments No comments

  2. JeffYang-MSFT 6,261 Reputation points Moderator
    2020-09-21T07:38:56.367+00:00

    Hi @Rat 999 ,
    Agree with Andy, and just as you mentioned, this issue only occurs when using plsql (utl_smtp or utl_mail) to send email, and it could work fine when driectly sending emails from outlook with the same list of recipients. So, I'm afraid the key of this issue is mainly related to the specific plsql method, please contact Oracle support for more information.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.