OraFAQ Forum: SQL & PL/SQL » utl_smtp Authentication POP3 before SMTP

Home » SQL & PL/SQL » SQL & PL/SQL » utl_smtp Authentication POP3 before SMTP - ORA-29279

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420363]

Fri, 28 August 2009 09:57

webdino73
Messages: 15
Registered: August 2005

Junior Member

Hello,

I use the utl_smtp pack and when I try to send email over my 1blu Mailaccount I received the following message

ORA-29279: SMTP permanent error: 503 AUTH command used when not advertised

I use the following code:

UTL_SMTP.command(l_mail_conn, 'AUTH LOGIN');
      UTL_SMTP.command(l_mail_conn,
                       UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.BASE64_ENCODE(UTL_RAW.CAST_TO_RAW(p_AuthUser))));
      UTL_SMTP.command(l_mail_conn,
                       UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.BASE64_ENCODE(UTL_RAW.CAST_TO_RAW(p_AuthPassword))));

The error is probably from the authentication method?
I don´t find the method which says the server to use smtp after pop. Has anyone help for me? thanks

Report message to a moderator

Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420364 is a reply to message #420363]

Fri, 28 August 2009 10:28

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

The server doesn't seem to support AUTH LOGIN.

Try to send a mail via a telnet connection first, so see what how the server is configured.

POP doesn't have anything to do with it, POP is for receiving mails.

Report message to a moderator

Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420365 is a reply to message #420364]

Fri, 28 August 2009 10:44

webdino73
Messages: 15
Registered: August 2005

Junior Member

sorry I don´t understand how to do this telnet connection

which authentication methods are possible?
I tried plain and login, are there others?

Report message to a moderator

Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420366 is a reply to message #420363]

Fri, 28 August 2009 10:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Does your organization own & manage SMTP server?
If not, I doubt any message will be accepted by it.

Report message to a moderator

Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420367 is a reply to message #420366]

Fri, 28 August 2009 11:02

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

If you don't understand how to do a telnet session, then you will have to ask the mail server administrator how the mail server is set up.

Report message to a moderator

Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420369 is a reply to message #420366]

Fri, 28 August 2009 11:14

webdino73
Messages: 15
Registered: August 2005

Junior Member

no the smtp server is on provider 1blu
we don´t manage the smtp server. 1blu support does not know these info Sad

Report message to a moderator

Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420370 is a reply to message #420369]

Fri, 28 August 2009 11:19

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Well, if 1blu doesn't know how they set up their own mail servers, nobody will know. Confused

Report message to a moderator

Previous Topic:	update a big table
Next Topic:	Package Dependencies

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 23 09:22:35 CDT 2025