UTL_SMPT authenticated login not working
AParmFeb 3 2011 — edited Feb 4 2011Hi there,
I am trying to send and email from a stored proc, I am connecting to an Exchange Server, I believe I am doing everything correctly, but I get the following error
ORA-29279: SMTP permanent error: 504 5.7.4 Unrecognized authentication type
here is my code..
mail_conn := utl_smtp.open_connection(mailhost, 587);
utl_smtp.command(mail_conn, 'AUTH LOGIN');
utl_smtp.command(mail_conn, utl_raw.cast_to_varchar2( utl_encode.base64_encode( utl_raw.cast_to_raw( my_username ))) );
utl_smtp.command(mail_conn, utl_raw.cast_to_varchar2( utl_encode.base64_encode( utl_raw.cast_to_raw( my_password ))) );
utl_smtp.mail(mail_conn, sender);
utl_smtp.rcpt(mail_conn, recipient);
utl_smtp.data(mail_conn, message);
utl_smtp.quit(mail_conn);
Anybody know why I get this error, I am running on 11G.
Thanks...