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!

ORA-29279: SMTP permanent error: 553

635315May 13 2008 — edited May 13 2008
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>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 10 2008
Added on May 13 2008
3 comments
2,554 views