My Oracle Support Banner

PLSQL: CHR(13)||CHR(10) DOES NOT WORK IN THE EMAIL BODY (Doc ID 1211776.1)

Last updated on FEBRUARY 08, 2019

Applies to:

PL/SQL - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

chr(13)||chr(10) in the code block below is supposed to create a newline but is only creating a space instead.




Following code but DID NOT resolve the issue

  1. UTL_SMTP.WRITE_DATA(mail_conn, utl_tcp.CRLF || 'Date work order was released on 30-JAN-2010'||utl_tcp.CRLF||'Date work order should be completed on 31-MAY-2010' );

  2. UTL_SMTP.WRITE_DATA(mail_conn,'Content-Type: text/plain; charset=utf-8'||utl_tcp.CRLF);

  3. Workaround from Bug 8973284:
    alter session set events '10590 trace name context forever, level 14';  



Cause

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
Symptoms
Cause
Solution
References


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