Home » SQL & PL/SQL » SQL & PL/SQL » Sending Mail ORA-29279: SMTP permanent error: 550 (oracle 10g )
Sending Mail ORA-29279: SMTP permanent error: 550 [message #478882] Wed, 13 October 2010 03:07 Go to next message
deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear all,

I'm trying to send email
using utl_mail

code is below
 BEGIN
 UTL_MAIL.send(
 sender => 'account@test1.com'
 ,recipients => 'acount@test2.com'
 ,subject => 'Test Mail'
 ,message => 'Hello World'
 ,mime_type => 'text; charset=us-ascii'
 ,priority => 3);
 END;


but getting following error

ERROR at line 1:
ORA-29279: SMTP permanent error: 550 <account@test2.com[/email]> No such user here
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 241
ORA-06512: at "SYS.UTL_MAIL", line 424
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 2

Can anyone help please

Thanks and Regards
Deepak

[Updated on: Wed, 13 October 2010 03:08]

Report message to a moderator

Re: Sending Mail ORA-29279: SMTP permanent error: 550 [message #478885 is a reply to message #478882] Wed, 13 October 2010 03:35 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
deepakmannazhi wrote on Wed, 13 October 2010 10:07

ORA-29279: SMTP permanent error: 550 account@test2.com No such user here


Can anyone help please ?


Yes, the administrator of the mail server. Or use a mail user that actually exist on the mail server.

[Updated on: Wed, 13 October 2010 03:36]

Report message to a moderator

Re: Sending Mail ORA-29279: SMTP permanent error: 550 [message #478886 is a reply to message #478885] Wed, 13 October 2010 03:40 Go to previous messageGo to next message
deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear thomas,

Do the recipients address should be in the same mail sever?

here sender is exists in mail server
receiver is an outside address what to do, please help

Regards
Deepak
Re: Sending Mail ORA-29279: SMTP permanent error: 550 [message #478887 is a reply to message #478886] Wed, 13 October 2010 03:52 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The mail server tells you "550 - No such user here" for the combination of sender an recipient you use. Perhaps the mail server doesn't accept mail relay request to outside addresses without authorisation. In that case the mail server would have to be configured to allow relay request from the oracle server without authorisation.

The only person who can help you in that regard is the mail server administrator.
Re: Sending Mail ORA-29279: SMTP permanent error: 550 [message #478889 is a reply to message #478887] Wed, 13 October 2010 04:23 Go to previous message
deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Thomas,

Thanks a lot for your kind help, i informed him, will give you feedback after doing this.

Regards
Deepak
Previous Topic: After row trigger problem
Next Topic: separate sign /
Goto Forum:
  


Current Time: Mon Aug 25 16:40:51 CDT 2025