Skip to Main Content

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-29279: SMTP permanent error: 550 5.7.1

user12251389Feb 21 2017 — edited Feb 21 2017

I have written small anonymous block which sends an email :

DECLARE

vSender VARCHAR2(30) := 'support@leo.com';

vRecip  VARCHAR2(30) := 'r.d@leosoftsys.com';

vSubj   VARCHAR2(50) := 'test';

vMesg   VARCHAR2(4000) := 'test';

vMType  VARCHAR2(30) := 'text/plain; charset=us-ascii';

BEGIN

utl_mail.send

(vSender, vRecip, NULL, NULL, vSubj, vMesg, vMType, NULL);

END;

When i execute this plsql blcock i am getting error as :

ORA-29279: SMTP permanent error: 550 5.7.1 <r.d@leo.com>: Recipient address rejected: Mail appeared to be SPAM or forged. Ask your Mail/DNS-Administrator to correct HELO and DNS MX settings or to get removed from DNSBLs; MTA helo: w010a893.k, MTA hostname: p50936657.dip0.t-ipconnect.de[80.147.102.87] (helo/hostname mismatch)

ORA-06512: at "SYS.UTL_MAIL", line 654

ORA-06512: at "SYS.UTL_MAIL", line 671

ORA-06512: at line 14

29279. 00000 -  "SMTP permanent error: %s"

*Cause:    A SMTP permanent error occurred.

*Action:   Correct the error and retry the SMTP operation.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 21 2017
Added on Feb 21 2017
8 comments
20,516 views