ORA-29279: SMTP permanent error: 535 5.7.8 Error: authentication failed: authentication failure — oracle-mosc

PL/SQL (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center