Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_SMTP and = character, e.g. =15 in an attachment

Duncan GardnerDec 21 2016 — edited Jan 12 2017

When I try writing "=15" in an email attachment, it comes though as the character "NAK". In fact these two commands

             UTL_SMTP.write_data     (c,                     '15, =15, <= 15%, =14, =13, =11, 11, =1.5,="15"' || UTL_TCP.crlf);

             UTL_SMTP.write_raw_data (c, UTL_RAW.cast_to_raw('15, =15, <= 15%, =14, =13, =11, 11, =1.5,="15"' || UTL_TCP.crlf));

both result in

15,  , < %,  ,  ,  , 11, =5,=5"

(Though this interface has stripped the characters out)

15,  [NAK], <[NAK] %,[DC4]  ,[DC3]  ,[DC1]  , 11, =5,=5"

99.9% of the file is OK, it's just some characters after the = symbol.

These are the preceding lines

         l_email_content := '--' || l_boundary_mixed || UTL_TCP.crlf;

         l_email_content := l_email_content || 'Content-Type: application/octet-stream; charset="utf-8"' || UTL_TCP.crlf;

         l_email_content := l_email_content || 'Content-Disposition: attachment; ' || UTL_TCP.crlf;

         l_email_content := l_email_content || ' filename="' || v_file || '"' || UTL_TCP.crlf;

         l_email_content := l_email_content || 'Content-Transfer-Encoding: quoted-printable' || UTL_TCP.crlf;

         l_email_content := l_email_content || UTL_TCP.crlf;

         l_email_content := l_email_content || UTL_TCP.crlf;

         UTL_SMTP.write_raw_data (c, UTL_RAW.cast_to_raw(l_email_content));

Oracle 12c

This post has been answered by Duncan Gardner on Jan 12 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2017
Added on Dec 21 2016
6 comments
955 views