Re: [Q] wield send mail from ORACLE ???
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Tue, 24 Apr 2007 19:15:09 +0100
It's pretty much certain to be the mailbody script.
Sadly for us we don't know what it contains.
If I was betting man, which I'm not, I'd hazard a guess that you hadn't
closed connections correctly - but we'll need to see the code (or an
equivalent without sensitive data that exhibits the same behaviour).
On 4/24/07, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
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
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
