Hi Experts,
I am using Command_SYS.Mail() function in Execute Online SQL to send a notification mail via custom event to users.
How can I add a new line in my variable (sending text) without using ‘HTML’ CONTENT TYPE ?
Thanks a lot for your help
Solved
Command_SYS.Mail - new line
Best answer by Charith Epitawatta
Hi
If the content type is text/plain in Mail Sender configuration, then the linefeed character is chr(13). Oracle interprets this into ‘\n’ new line character. You can structure your email message as below:
Eg:
BEGIN
command_sys.mail('','example@email.com','Line1'||chr(13)||'Line2');
END; If the content type is text/html, then you can use the <br> HTML tag.
Eg:
BEGIN
command_sys.mail('','example@email.com','Line1<br>Line2');
END; Hope this helps!
This topic has been closed for replies.
+31Hi
If the content type is text/plain in Mail Sender configuration, then the linefeed character is chr(13). Oracle interprets this into ‘\n’ new line character. You can structure your email message as below:
Eg:
BEGIN
command_sys.mail('','example@email.com','Line1'||chr(13)||'Line2');
END; If the content type is text/html, then you can use the <br> HTML tag.
Eg:
BEGIN
command_sys.mail('','example@email.com','Line1<br>Line2');
END; Hope this helps!
Charith - https://charith.pro
+16Hello
If you set up your mail_sender with content-type : text/plain, as
Try to setup like this way to use chr(13) characters in your email body. In Oracle \n character is not supported to add new lines.
Cheers!
+19A standards-compliant email message would use both a carriage return and a line feed to represent a new line.
'Line 1' || CHR(13) || CHR(10) || 'Line 2'
/*
CR = 13
LF = 10
*/
- Windows uses CR+LF, as does the specification for emails.
- UNIX and UNIX-like operating systems use LF (e.g. AIX, Solaris, HP-UX, Linux, Mac OS X, Android, FreeBSD, Minix)
- Mac OS 9 used CR.
In the bad old days, if you sent a UNIX-style LF, email servers written to the letter of the RFC spec would complain of a “naked line feed”.
However, even if you take care to do this correctly, Microsoft Outlook might still remove them:
Line breaks are removed in posts made in plain text format - Outlook | Microsoft Docs
Table from asciitable.com:
If you find this forum useful, please consider paying back to the community in your own areas of expertise. If you ask for help in a private message, please know that I will likely repost it as a forum question (with your personal details redacted) and answer it publicly. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.