DokuWiki

It's better when it's simple

User Tools

Site Tools


apex:mail

This is an old revision of the document!


E-Mail Versand

Package APEX_MAIL

apex_mail.sql
DECLARE
 
    L_TIMESTAMP   VARCHAR2(20);
 
BEGIN
    L_TIMESTAMP := TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS');
 
    APEX_MAIL.SEND(
       P_FROM => 'noreply@nowhere.org'
     , P_TO   => 'unknown@nowhere.org'
     , P_SUBJ => 'Test APEX_MAIL.SEND '  || L_TIMESTAMP || '(do not reply)' 
     , P_BODY => 'Dies ist Test mit APEX_MAIL.SEND (' || L_TIMESTAMP || ')');
 
    APEX_MAIL.PUSH_QUEUE;
 
END;

View WWV_FLOW_USER_MAIL_LOG

Diese View zeigt die versendeten Mails an.

wwv_flow_user_mail_log.sql
SELECT *
FROM   APEX_050100.WWV_FLOW_USER_MAIL_LOG;
apex/mail.1652621963.txt.gz · Last modified: 2022-05-15 15:39 by 87.153.21.232

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki