Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_SMPT authenticated login not working

AParmFeb 3 2011 — edited Feb 4 2011
Hi 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2011
Added on Feb 3 2011
10 comments
8,942 views