ORA-29279: SMTP permanent error: 535 5.7.8 Error: authentication failed: authentication failure
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Error trying to send email via utl_smtp, I NEED to use AUTH CRAM-MD5, because APEX_MAIL use it.
declare
mail_conn utl_smtp.connection;
mailhost constant varchar2(30) := 'mymailhost.gov.br';
username constant varchar2(20) := 'user@gov.br';
pass constant varchar2(30) := 'mypass';
begin
mail_conn := utl_smtp.open_connection(mailhost, 25);
UTL_SMTP.EHLO(mail_conn, mailhost);
UTL_SMTP.AUTH(c => mail_conn,username => username, password => pass);
utl_smtp.close_data(mail_conn);
utl_smtp.quit (mail_conn);
end;
ORA-29279: SMTP permanent error: 535 5.7.8 Error: authentication failed: authentication failure
Thanks.
André Faria