You can use the APEX_MAIL
package to send an email from an Oracle Application Express application. APEX_MAIL
contains three procedures for sending, delivering and adding attachments to emails.
Use APEX_MAIL.SEND
to send an outbound email message from your application. Use APEX_MAIL.PUSH_QUEUE
to deliver mail messages stored in APEX_MAIL_QUEUE
. Use APEX_MAIL.ADD_ATTACHMENT
to send an outbound email message from your application as an attachment.
Example:
BEGIN APEX_Mail.Send( 'to@email-address.com', 'from@email-address.com', 'This is some test plain text', 'This is some test <b>HTML</b>', 'Test Email Subject' ); APEX_Mail.Push_Queue; END; /
Note:
There is a built in limit of 5000 emails in any given 24 hour period. If you try to send more, you get an error.
To learn more, see APEX_MAIL in Oracle Application Express API Reference.
No. | Subject |
---|---|
Notice | Certification Oracle SQL Developer |
114 | SIMPLE EMAIL |
113 | Network access denied by access control list (ACL) in Oracle Database 11g |
112 | CREATE NETWORK ACL |
111 | Email 5 |
110 | ACL FUNCTION |
109 | PL/SQL Email |
108 | DSLR Vs. Camcorder: What Tech Is Better For Video? |
107 | Here Are the Default Gmail SMTP Settings |
106 | |
105 | IMP/EXP |
104 | SMTP server |
103 | CHART |
102 | chadmoon |
101 | INNER Join |
100 | LOOP -1 |
99 | UPDATE SQL |
98 | TRANSFER |
97 | PORT Setup |
» | Sending Emails |
95 | How to add a sequence column to an existing table with records |