Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Utl_smtp new line characters

user532091Feb 4 2010 — edited Feb 4 2010
Hi

i'm able to send emails using utl_smtp utility.
But the issue is i need to send TEXT emails which have new line characters chr(10)

But somehow the emails are sent using HTML tags.. CANT WE HAVE new line characters using chr(10)



Meaning.

If i use the body as and pass it to utl_smtp package
-----------------------------------------------------------------------------------------------------------------------------------
v_message_content :=
'This is test message line1'|| chr(10)||
'This is test message line2'|| chr(10)||
'This is test message line3'|| chr(10);




The email i get is :

This is test message line1 This is test message line2 This is test message line3

No new line characters

-----------------------------------------------------------------------------------------------------------------------------------
And if i use <BR> as in html tag for new line

v_message_content :=
'This is test message line1 <BR>'|| chr(10)||
'This is test message line2 <BR>'|| chr(10)||
'This is test message line3 <BR>'|| chr(10);


Then email i get is


This is test message line1
This is test message line2
This is test message line3
-----------------------------------------------------------------------------------------------------------------------------------

does utl_smtp take only html tags for new line characters.
Please help me in this regard

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2010
Added on Feb 4 2010
3 comments
4,582 views