Declare
l_body clob;
l_body_html clob;
begin
l_body := 'To view the content of this message, please use an HTML enabled mail client.' || utl_tcp.crlf;
apex_mail.send (
p_to => '[email protected]', -- change to your email address
p_from => '[email protected]', -- change to a real senders email address
p_body => l_body,
p_body_html => l_body_html,
p_subj => 'APEX MAIL' );
apex_mail.push_queue();
end;
Aru
Hi,
Are you hitting with any errors while trying to send email
Are you able to send mails successfully using UTL_SMTP
Regards
Aru
Zulqarnain Haider
Hi Aru
This error when i Send Emai.
ORA-29279: SMTP permanent error: 503 5.5.1 bad sequence of commands
Vinish Kapoor
Please show the PL/SQL code you are executing.
Zulqarnain Haider
Vinish Kapoor
Your code seems ok. I ran and got the email.
Try login into Oracle Apex administration services and click on the Instance setting. There you need to check by changing the configuration settings.
Zulqarnain Haider
Hi Sir Vinish
My Intance Setting is ok.Its possible to Send your ACL and UTL_SMTP then i will check what i am wrong.