Print

Emailing from APEX

Posted in General Application.

You can send emails from APEX with the HTMLDB_MAIL  package.

For example:

 

HTMLDB_MAIL.SEND(
P_TO      => v_email,
P_FROM    => v_from,
p_body    => v_body,
P_BODY_HTML    => v_body_HTML,
P_SUBJ    => v_subject
);

 

 

Note:

Before you can send email from an Application Builder application, you must:

Log in to Oracle Application Express Administration Services and configure the email settings on the Instance Settings page. See in Oracle Application Express Administration Guide.

 

 

About Me

I currently specialise in developing bespoke applications using Oracle APEX.I have worked with APEX since it was known as HTMLDB, but have also dabbled with E-Business Suite, Oracle AS Portal, ECM, Webcenter and Website Design.

I enjoy working with new clients and assisting them develop custom applications to enhance and improve internal business processes.

Find Me

mandy nerd2