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!

Embedding an image into email sent from ApEx

471385Jun 20 2008 — edited Jun 20 2008
Hello.

I have been wrestling with trying to embed an image stored in my ApEx app workspace into the email message that gets generated from my ApEx application.

I have followed the guidelines I found in another post.

The emails get generated fine, but the in place of the image I always get a "broken image" icon. Below is the code. If someone could help me see where the code is wrong, I would greatly appreciate it.

CREATE OR REPLACE procedure [my_procedure_name]
(
[input variables]
)
is

l_body clob;
l_body_html clob;
[my other variables declarations]

begin

DBMS_LOB.CREATETEMPORARY(l_body_html,true);

...

l_body := v_efax_code||utl_tcp.crlf;

l_body_html := '

< html >

< p align="center" >< img style="WIDTH: 386px; HEIGHT:
51px" height="99" alt="'||v_doing_business_as||'" hspace="0" src="'||v_application_root||'/'||Apex_Application.g_company_images||'company_logo.GIF" width="374" border =0 >< /p >

[other pertinent HTML code]

< /html >
';


apex_mail.send (
p_to => v_to,
p_from => v_from,
p_body => l_body,
p_body_html => l_body_html,
p_subj => 'Letter'
);

apex_mail.push_queue (
p_smtp_hostname => v_smtp_hostname,
p_smtp_portno => v_smtp_portno
);

end;
/

Thank You

P.S. Sorry I had to put extra space between every " < " and " > " signs to get my discussion forum note to display the HTML snippets literally.

Boris
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2008
Added on Jun 20 2008
2 comments
1,774 views