2 Replies Latest reply on Dec 21, 2011 11:33 AM by user396453

    That domain isn't in my list of allowed rcpthosts (#5.7.1)

      I want send the email from oracle database.
      So I did the following steps


      3.alter system set smtp_out_server = 'webmail.vilsoft.co.in:25' scope=both;

      4.exec utl_mail.send(sender=> 'Id1@vilsoft.co.in',recipients=>'Id2@vilsoft.co.in',subject=>'test mail',message=>'hi');

      PL/SQL procedure successfully completed.

      So the mail is send to Destination Correctly.

      But When I want to send the mail from one server to another server So i execute the following query

      SQL> exec utl_mail.send(sender=> 'ID1@vilsoft.co.in',recipients=>'Id2@gmail.com',subject=>'test mail',message=>'hi');

      then following error occurs....

      BEGIN utl_mail.send(sender=> 'ID1@vilsoft.co.in',recipients=>'Id2@gmail.com',subject=>'test mail',message=>'hi'); END;

      ERROR at line 1:
      ORA-29279: SMTP permanent error: 553 sorry, that domain isn't in my list of
      allowed rcpthosts (#5.7.1)
      ORA-06512: at "SYS.UTL_SMTP", line 20
      ORA-06512: at "SYS.UTL_SMTP", line 98
      ORA-06512: at "SYS.UTL_SMTP", line 240
      ORA-06512: at "SYS.UTL_MAIL", line 424
      ORA-06512: at "SYS.UTL_MAIL", line 594
      ORA-06512: at line 1

      So Please help me to resolve this error ...

      Edited by: 901580 on Dec 21, 2011 2:42 AM