today:
286
yesterday:
590
Total:
1,737,439

Technology

EMAIL PROCEDURE

admin 2018.12.08 18:03 Views : 333

DECLARE 

TESTEMAIL VARCHAR2(100);

EMAIL_LIST VARCHAR2(100);

EMAIL_COUNT NUMBER;

 

BEGIN

 

 SELECT COUNT(*) INTO EMAIL_COUNT FROM TEST_EMAIL; 

 FOR i IN 1..EMAIL_COUNT 

  

LOOP 

   SELECT TESTEMAIL INTO EMAIL_LIST FROM TEST_EMAIL WHERE ID = i;

  APEX_MAIL.SEND( 

    p_to => EMAIL_LIST , 

    p_from => 'admin@solatoz.com', 

    p_subj => 'APEX_MAIL admin@solatoz.com - 12/8/2018...6:51PM', 

    p_body => 'Please Check email.', 

    p_body_html => '<b>UTL_SMTP network allow</b>&TESTEMAIL. New email account... 12/8/2018...6:51PM ...HOME '

    );

END LOOP;

END;