Command to Send EMail:
DECLARE
l_id number;
BEGIN
l_id := APEX_MAIL.SEND (p_to => 'srm.jay@gmail.edu',
p_from => 'srm.jay@stanford.edu',
p_subj => 'APEX_MAIL from imguat',
p_body => 'Please review the attachment.',
p_body_html => '<b>Please</b> review the attachment');
COMMIT;
END;
/
begin
APEX_MAIL.PUSH_QUEUE('localhost','25');
end;
/
Please check the apex_mail_log table for any errors or warnings.
select mail_send_error from APEX_MAIL_LOG ;
DECLARE
l_id number;
BEGIN
l_id := APEX_MAIL.SEND (p_to => 'srm.jay@gmail.edu',
p_from => 'srm.jay@stanford.edu',
p_subj => 'APEX_MAIL from imguat',
p_body => 'Please review the attachment.',
p_body_html => '<b>Please</b> review the attachment');
COMMIT;
END;
/
To send a mail immediately from the apex mail queue:
Oracle Application Express logs successfully submitted message in the table APEX_MAIL_LOG with the timestamp reflecting your server's local time.
APEX_MAIL.PUSH_QUEUE('localhost','25');
end;
/
Please check the apex_mail_log table for any errors or warnings.
select mail_send_error from APEX_MAIL_LOG ;
No comments:
Post a Comment