Utl_smtp Does Not Escape Period (DOT) and Raise ORA-29279 (Doc ID 806105.1)

Last updated on MARCH 04, 2022

Applies to:

Symptoms

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);

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.