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!

Line feed in mail messages

Earl LewisNov 14 2007 — edited Nov 14 2007
I'm creating/sending email message using both utl_smtp and utl_mail and finding that when I insert line feeds using chr(13) at the end of lines that they seem to be handled 'inconsistently'. Most of the time they obligingly insert a line feed and the next line appears where you would expect it (i.e. on the next line) but sometimes they don't.

I know this is a bit ambiguous as a problem description but I don't have any way of explaining it any better. Here's a block of code that I'm using as an example:
message := 'BEGIN:VCALENDAR' || chr(13);
message := message || 'PRODID:-//University of Something//NONSGML Project Tracker//EN' || chr(13);
message := message || 'METHOD:REQUEST' || chr(13);
message := message || 'VERSION:2.0' || chr(13);
message := message || 'BEGIN:VTODO' || chr(13);
message := message || 'SEQUENCE:0' || chr(13);
message := message || 'UID:u0363644-20071113@host.domain.com' || chr(13);
message := message || 'ORGANIZER:MAILTO:some.name@some.domain.com' || chr(13);
message := message || 'ATTENDEE;PARTSTAT=ACCEPTED:mailto:some.name@some.domain.com' || chr(13);
message := message || 'DUE:20071215T165959-0700' || chr(13);
message := message || 'STATUS:NEEDS-ACTION' || chr(13);
message := message || 'SUMMARY:Project review' || chr(13);
message := message || 'END:VTODO' || chr(13);
message := message || 'END:VCALENDAR';
Here is what it looks like when it's rendered in the mail client (Outlook 2003):
BEGIN:VCALENDAR
PRODID:-//University of Something//NONSGML Project Tracker//EN METHOD:REQUEST VERSION:2.0 BEGIN:VTODO SEQUENCE:0 UID:u0363644-20071113@some.domain.com
ORGANIZER:MAILTO:some.name@some.domain.com
ATTENDEE;PARTSTAT=ACCEPTED:mailto:some.name@some.domain.com
DUE:20071215T165959-0700
STATUS:NEEDS-ACTION
SUMMARY:Project review
END:VTODO
END:VCALENDAR
Notice how the METHOD:REQUEST, and others, aren't wrapping when they've got a line feed after them?

Anyone else seeing this or got any ideas on why it might be happening?

Earl
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2007
Added on Nov 14 2007
8 comments
2,592 views