Differences

This shows you the differences between two versions of the page.

--- apex:mail [2022-05-15 15:39] – created 87.153.21.232
+++ apex:mail [2022-05-17 11:09] (current) – removed Aleksandr
@@ Line 1: / Line 1: @@
-====== E-Mail Versand ======
-===== Package APEX_MAIL =====
-<file plsql 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;
-</file>
-===== View WWV_FLOW_USER_MAIL_LOG =====
-Diese View zeigt die versendeten Mails an.
-<file plsql wwv_flow_user_mail_log.sql>
-SELECT *
-FROM   APEX_050100.WWV_FLOW_USER_MAIL_LOG;
-</file>