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.
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
- 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' );
- UTL_SMTP.WRITE_DATA(mail_conn,'Content-Type: text/plain; charset=utf-8'||utl_tcp.CRLF);
- Workaround from Bug 8973284:
alter session set events '10590 trace name context forever, level 14';
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