Hi, we are facing error in utl_smtp mail send from oracle 19c using smtp authentication.

we are getting mail through dbms_sheduler event based proc with same smtp and pwd.

we are using below mentioned code and steps:

step 1-

begin

 -- Allow SMTP access for user ADMIN

 dbms_network_acl_admin.append_host_ace(

  host =>'******',

  lower_port => 587,

  upper_port => 587,

  ace => xs$ace_type(privilege_list => xs$name_list('SMTP'),

  principal_name => 'SYS',

  principal_type => xs_acl.ptype_db));

end;

/

step -2

CREATE OR REPLACE PROCEDURE SEND_MAIL (

 msg_to varchar2,

 msg_subject varchar2,

 msg_text varchar2 ) 

IS

 mail_conn utl_smtp.connection;

 username varchar2(1000):= '***';

 passwd varchar2(50):= '****';

 msg_from varchar2(50) := '****';