Sending e-mail from APEX

Oracle APEX provides the htmldb_mail PL/SQL package to facilitate the sending of email messages directly from online Oracle applications.  OTN has a description of using htmldb_mail here.

The htmldb_mail packages does not interface directly with your server sendmail utility.  Instead, the htmldb_mail package (a synonym for the wwv_flow_mail package) stores the outbound e-mail in a message queue that is managed by dbms_scheduler.  Some developers prefer using the www_flow_mail package directly for sending e-mail from Apex.

Prerequisites:

You will need the APEX application, Oracle , and you must enable the utl_smtp software.  You install the utl_smtp package and Oracle Jserver by running the following DBA scripts as SYSDBA (SYS user):

SQL> @$ORACLE_HOME/javavm/install/initjvm.sql

SQL> @$ORACLE_HOME/rdbms/admin/initplsj.sql

The htmldb_mail package

A sample Oracle email session from APEX

Sending an e-mail from APEX is trivial.  All you need to do is define a process (called, say "send_html_db_email") with the proper arguments to htmldb_mail.send:

SEE CODE DEPOT FOR FULL SCRIPTS

In the example above, the message_text column is defined as a varchar2(1000) and APEX will do the text wrapping in the e-mail message.

To send multiple e-mails from a multiple select LOV (list of values drop down), click here.

Click here for details on managing APEX Mail Messages.

APEX developer support:

For APEX development support just call to gat an Oracle Certified professional for all APEX development projects.

For more information on this topic, see the book "Easy Oracle HTML-DB Application Express ", the best book anywhere on expert APEX development:

Easy Oracle HTML-DB Application Express By Michael Cunningham & Kent Crotty Only $27.95 Buy it now and get the code depot download