[Q] wield send mail from ORACLE ???

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Tue, 24 Apr 2007 06:43:54 -0700 (PDT)
Message-ID: <663824.29805.qm@web60823.mail.yahoo.com>

We have ORACLE 9.2.0.8 and 10.2.0.2 on Redhat servers (4.3). I tried to send mail from ORACLE (we use utl_smtp.data( conn, mesg );). We always get one time work, second time fail repeatly. Does any one know why??

---

SQL> @mailbody
 32 .
SQL> / PL/SQL procedure successfully completed.

SQL> /
Declare
*

ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available

ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 96
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at line 15

SQL> / PL/SQL procedure successfully completed.

SQL> /
Declare
*

ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available

ORA-06512: at "SYS.UTL_SMTP", line 17
ORA-06512: at "SYS.UTL_SMTP", line 96
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at line 15


__________________________________________________

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 24 2007 - 08:43:54 CDT