Re: [Q] wield send mail from ORACLE ???

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_at_yahoo.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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