3 Replies Latest reply on May 13, 2008 3:08 PM by 635315

    ORA-29279: SMTP permanent error: 553

    635315
      Hi,
      This what i do in SQL Plus and receive an error. What i do wrong?
      Thanks

      SQL> connect system/oracle as sysdba;
      Connected.

      SQL> $ORACLE_HOME/javavm/install/initjvm.sql;

      SQL> $ORACLE_HOME/javavm/install/init_jis.sql;

      SQL> $ORACLE_HOME/rdbms/admin/initplsj.sql;

      SQL> CREATE OR REPLACE PROCEDURE SEND_MAIL (msg_to varchar2, msg_subject varchar2, msg_text varchar2
      )
      2 IS
      3 c utl_smtp.connection;
      4 rc integer;
      5 msg_from varchar2(50) := 'root@florya.co.uk';
      6 mailhost VARCHAR2(30) := 'authsmtp.streamline.net'; -- local database host
      7
      8 BEGIN
      9 c := utl_smtp.open_connection(mailhost, 25); -- SMTP on port 25
      10 utl_smtp.helo(c, mailhost);
      11 utl_smtp.mail(c, msg_from);
      12 utl_smtp.rcpt(c, msg_to);
      13
      14 utl_smtp.data(c,'From: Oracle Database' || utl_tcp.crlf ||
      15 'To: ' || msg_to || utl_tcp.crlf ||
      16 'Subject: ' || msg_subject ||
      17 utl_tcp.crlf || msg_text);
      18
      19 utl_smtp.quit(c);
      20
      21 END;
      22 /

      Procedure created.

      SQL> EXEC SEND_MAIL ('root@florya.co.uk', 'Hello from Oracle', 'This is a message');
      BEGIN SEND_MAIL ('root@florya.co.uk', 'Hello from Oracle', 'This is a message'); 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 21
      ORA-06512: at "SYS.UTL_SMTP", line 99
      ORA-06512: at "SYS.UTL_SMTP", line 241
      ORA-06512: at "SYS.SEND_MAIL", line 12
      ORA-06512: at line 1


      SQL>