Home » SQL & PL/SQL » SQL & PL/SQL » utl_smtp Authentication POP3 before SMTP - ORA-29279
utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420363] Fri, 28 August 2009 09:57 Go to next message
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
Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420364 is a reply to message #420363] Fri, 28 August 2009 10:28 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.
Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420365 is a reply to message #420364] Fri, 28 August 2009 10:44 Go to previous messageGo to next message
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?
Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420366 is a reply to message #420363] Fri, 28 August 2009 10:55 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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.
Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420367 is a reply to message #420366] Fri, 28 August 2009 11:02 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.
Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420369 is a reply to message #420366] Fri, 28 August 2009 11:14 Go to previous messageGo to next message
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
Re: utl_smtp Authentication POP3 before SMTP - ORA-29279 [message #420370 is a reply to message #420369] Fri, 28 August 2009 11:19 Go to previous message
ThomasG
Messages: 3189
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
Previous Topic: update a big table
Next Topic: Package Dependencies
Goto Forum:
  


Current Time: Sun Dec 04 02:49:37 CST 2016

Total time taken to generate the page: 0.19384 seconds