apex:mail
This is an old revision of the document!
Table of Contents
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