[Q] wield send mail from ORACLE ???
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 24 Apr 2007 06:43:54 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » [Q] wield send mail from ORACLE ???
