Home » SQL & PL/SQL » SQL & PL/SQL » Unable to Send Mail Using UTL SMTP
Unable to Send Mail Using UTL SMTP [message #578905] Wed, 06 March 2013 04:24 Go to next message
shah mohammed
Messages: 1
Registered: March 2013
Location: Bangalore
Junior Member
Hi All,

I am using utl_smtp to send emails. I am getting the below error message.

Error in XX(Package name) ORA-29279: SMTP permanent error: 501 5.5.2 Syntax error in parameters scanning "TO" at - 5150
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 6000
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7250
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 8450.

Could you please let me know what could be the reason?

I have checked the mail id in the "TO" list and found them to be valid. Is there could be any other reason?

I have run this package in test instance and it is working fine. I am able to receive mails. In the test instance, I have put my mail id in the to list.

Please let me know what other option do I need to check.

Thanks,
Shoeb.

Report message to a moderator

Re: Unable to Send Mail Using UTL SMTP [message #578906 is a reply to message #578905] Wed, 06 March 2013 04:34 Go to previous message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If only you told us HOW you tried to send e-mail using UTL_SMTP ...

Anyway: if the same works in your test environment, compare it to production, find differences and make necessary adjustments.

Report message to a moderator

Previous Topic: Horizontal Partitioning
Next Topic: Rebuild index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 03 15:00:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.