Hi Oracle Gurus..
Given below are smtp_out_server parameter setting & other configuration settings.
ALTER SYSTEM SET smtp_out_server = 'email-smtp.us-west-1.webmail.com:2587' SCOPE=both;
created the ACL using following code
begin
dbms_network_acl_admin.create_acl (
acl => 'utl_mail.xml',
description => 'Enables mail to be sent',
principal => 'ROB_DR',is_grant => true,
privilege => 'connect');
end;
/
Assigning the access control list to the outgoing SMTP network host for your e-mail server...
begin
dbms_network_acl_admin.assign_acl (
acl => 'utl_mail.xml',
host => 'email-smtp.us-west-1.webmail.com',
lower_port => 2587,
upper_port=> 2587);
end;
/
granted permission to use it....
begin
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'utl_mail.xml',
principal => 'ROB_DR',
is_grant => TRUE,
privilege => 'connect');
end;
/
Finally i tested to send mail using following plsql code
begin
utl_mail.send(sender => 'robd@artex.com',
recipients => 'robd@artex.com',
subject => 'Test utl_mail.send procedure',
message => 'If you are reading this it worked!');
end;
/
ERROR at line 1:
ORA-29279: SMTP permanent error: 530 Authentication required
ORA-06512: at "SYS.UTL_MAIL", line 662
ORA-06512: at "SYS.UTL_MAIL", line 679
ORA-06512: at line 2
it returns ORA-29279: SMTP permanent error: 530 Authentication required error. please help me in this regard.
Thanks in advance.
Regards,
Raj