 |
|
| Computers Forum Index » Computer - Databases - Oracle (Server) » utl_smtp issue... |
|
Page 1 of 1 |
|
| Author |
Message |
| Taurus... |
 Posted: Thu Oct 29, 2009 1:46 pm |
|
|
|
Guest
|
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;">
and receive at client side
<td
style="border-style: inset inset inset none; border-color: -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;">
Thus my border color information is lost.
Anyone a clue how to avoid this issue?
Thanks,
Patrick |
|
|
| Back to top |
|
|
|
| frank.van.bortel at (no spam) gmail.com... |
| Posted: Thu Oct 29, 2009 2:16 pm |
|
|
|
Guest
|
On 29 okt, 14:46, Taurus <p.neum... at (no spam) kabelmail.de> wrote:
Quote: 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;"
and receive at client side
td
style="border-style: inset inset inset none; border-color: -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;"
Thus my border color information is lost.
Anyone a clue how to avoid this issue?
Thanks,
Patrick
Blame the client |
|
|
| Back to top |
|
|
|
| Taurus... |
| Posted: Thu Oct 29, 2009 2:27 pm |
|
|
|
Guest
|
On 29 Okt., 15:16, "frank.van.bor... at (no spam) gmail.com"
<frank.van.bor... at (no spam) gmail.com> wrote:
Quote: On 29 okt, 14:46, Taurus <p.neum... at (no spam) 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;"
and receive at client side
td
style="border-style: inset inset inset none; border-color: -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;"
Thus my border color information is lost.
Anyone a clue how to avoid this issue?
Thanks,
Patrick
Blame the client
I suppose the issue is related to the server as other applications are
able to pass the correct string. |
|
|
| Back to top |
|
|
|
| Steve Howard... |
| Posted: Thu Oct 29, 2009 5:19 pm |
|
|
|
Guest
|
On Oct 29, 9:46 am, Taurus <p.neum... at (no spam) kabelmail.de> wrote:
Quote: 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;"
and receive at client side
td
style="border-style: inset inset inset none; border-color: -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;"
Thus my border color information is lost.
Anyone a clue how to avoid this issue?
Thanks,
Patrick
I just tried your code on 10.2.0.4 and it output the entire string
with the rgb calls. Do you have a 10g environment where you can test? |
|
|
| Back to top |
|
|
|
| Malcolm Dew-Jones... |
| Posted: Thu Oct 29, 2009 10:43 pm |
|
|
|
Guest
|
Taurus (p.neumann at (no spam) 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 |
|
|
| Back to top |
|
|
|
| Vladimir M. Zakharychev... |
| Posted: Fri Oct 30, 2009 5:56 am |
|
|
|
Guest
|
On Oct 29, 4:46 pm, Taurus <p.neum... at (no spam) kabelmail.de> wrote:
Quote: 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;"
and receive at client side
td
style="border-style: inset inset inset none; border-color: -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;"
Thus my border color information is lost.
Anyone a clue how to avoid this issue?
Thanks,
Patrick
First of all, you need to confirm that the string you output is indeed
not being transformed in transit or by the SMTP server (there might be
filters on the SMTP server that apply certain transformations to
received emails, and there might be content filters on the network
borders.) You could also use some TCP dumper or logging proxy between
your application (sender) and the server.
You can also rewrite your CSS to some equivalent and see if this makes
any difference: try "border-color: #d88b4c #d88b4c #d88b4c -moz-use-
text-color;" instead of rgb().
Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Wed Nov 25, 2009 9:38 am
|
|