Re: utl_smtp issue

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 29 Oct 2009 11:43:50 -0700
Message-ID: <4ae9e266$1_at_news.victoria.tc.ca>

Taurus (p.neumann_at_kabelmail.de) wrote:
: Hi,

: I'am using Oralce 9i utl_smtp package to send html mails and facing an
: issue.
: My smtp configuration is as follows:

: utl_smtp.write_data(connection, 'MIME-Version: 1.0' || cCRLF);
: utl_smtp.write_data(connection, 'Content-Type: text/html;
: charset="UTF-8"' || cCRLF);

: I'am passing following line to umtl_smtp

: <td style="border-style: inset inset inset none; border-color: rgb
: (216, 139, 76) rgb(216, 139, 76) rgb(216, 139, 76) -moz-use-text-
: color; border-width: 1pt 1pt 1pt medium; padding: 0.75pt; background:
: rgb(255, 246, 185) none repeat scroll 0%; -moz-background-clip:
: initial; -moz-background-origin: initial; -moz-background-inline-
: policy: initial;">

That is not the actual(s) line of code you use. I guess the code involves concatenating some strings. Perhaps there is simple typo in the code

	s := '<td style="border-style: ..etc...'
	  || rgb(216, 139, 76)
	  || '-moz-use-text- ..etc...';

so for example if function rgb exists then you would get no compile error, but that wouldn't be quite the string you thought you were sending at all.

Anyway, I would double check what is being produced. It is also conceivable that something (like a spam checker?) is modifying the html after you send it, so as I said, I would first double check exactly what is going into umtl_smtp and exactly what is being sent. Use TCPDUMP or similar to confirm what traffic is actually being produced.

$0.10 Received on Thu Oct 29 2009 - 13:43:50 CDT