Skip to Main Content

APEX

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!

HTMLDB_MAIL problem when sending HTML format mail to YAHOO account

tj416616anMar 22 2004 — edited Sep 8 2006
Hi,

I used the following PL/SQL code to send a HTML format e-mail to yahoo account. However, after I received the e-mail, it's all blank. If I do NOT use the p_body_html parameter, plain text messages assigned to p_body showed up in received e-mail. I've also tried some EPA accounts and they all resulted in empty mail body but subject line. Hotmail account and all others worked fine.

Thank you,
Tony

==

DECLARE
l_email_body varchar2(4000);
BEGIN
l_email_body := '<html><body>This is a <b>TEST</b>.</body></html>';

htmldb_mail.send(
p_to => 'xxx@yahoo.com',
p_from => 'xxx@yahoo.com',
p_body => 'YAHOO mail test',
p_body_html => l_email_body,
p_subj => 'YAHOO mail test');

END;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2006
Added on Mar 22 2004
7 comments
698 views