Utl_smtp Does Not Escape Period (DOT) and Raise ORA-29279
(Doc ID 806105.1)
Last updated on MARCH 04, 2022
Applies to:PL/SQL - Version 126.96.36.199 and later
Information in this document applies to any platform.
This problem can occur on any platform.
1. Sending the mail using UTL_SMTP package, if the message body is starting with the "." (dot) then the entire message body will get truncated.
i.e. If the code is written as UTL_SMTP.write_data(objConnection, '.test' || CRLF);
2. If the line that is written has got only a dot as shown below, then it raises exception
i.e.UTL_SMTP.write_data(objConnection, '.' || CRLF);
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document