Embedding an image into email sent from ApEx
471385Jun 20 2008 — edited Jun 20 2008Hello.
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