RE: SMTP error

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 26 Jul 2005 09:12:06 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FA86@EXCNYSM0A1AJ.nysemail.nyenet>

Do you have a leading space in the ip address? Try changing it to a local variable?

DECLARE
v_connection UTL_SMTP.CONNECTION;
v_ipaddr varchar2(20) := '192.9.200.8'; <====

BEGIN
v_connection := UTL_SMTP.OPEN_CONNECTION(v_ipaddr,25); <=== UTL_SMTP.HELO(v_connection,v_ipaddr); <=== UTL_SMTP.MAIL(v_connection,' pasha_at_oneapps.com
<mailto:pasha_at_oneapps.com> ');

  UTL_SMTP.RCPT(v_connection,'moqthiyar_at_yahoo.com');
  UTL_SMTP.DATA(v_connection,'Sent From PL/SQL'); 
  UTL_SMTP.QUIT(v_connection);

END;
/

From: Onkar N Tiwary [mailto:onkarnath.tiwary_at_gmail.com] Sent: Tuesday, July 26, 2005 9:05 AM
To: Mercadante, Thomas F (LABOR)
Cc: oracle-l_at_freelists.org
Subject: Re: SMTP error

Thanx for the quick response Tom but using the same server we are sending mails using JSP code but when I am trying to send mail via same server usiing oracle proc , its giving the error...

On 7/26/05, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante_at_labor.state.ny.us> wrote:

Onkar,

This means that the mail server is either not at that ip address or you cannot reach it

Hope this helps.

Tom

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary Sent: Tuesday, July 26, 2005 7:49 AM
To: oracle-l_at_freelists.org
Subject: SMTP error

Hi all,

I am trying to send mail using the following procedure. its just the simple one but i am getting the error however SMTP service is configured on the system and initplsj.sql and initjvm.sql(if not wrong) has been executed successfully. Need ur valuable comments.

SQL> ed
Wrote file afiedt.buf

  1 DECLARE
  2 v_connection UTL_SMTP.CONNECTION;
  3 BEGIN
  4 v_connection := UTL_SMTP.OPEN_CONNECTION(' 192.9.200.8
<http://192.9.200.8/> ',25);

  5 UTL_SMTP.HELO(v_connection,' 192.9.200.8 <http://192.9.200.8/> ');   6 UTL_SMTP.MAIL(v_connection,' pasha_at_oneapps.com
<mailto:pasha_at_oneapps.com> ');

  7  UTL_SMTP.RCPT(v_connection,'moqthiyar_at_yahoo.com');
  8  UTL_SMTP.DATA(v_connection,'Sent From PL/SQL'); 
  9  UTL_SMTP.QUIT(v_connection);

10* END;
SQL> /
DECLARE
*
ERROR at line 1:

ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at " SYS.UTL_SMTP", line 97
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at line 4

TIA

-- 
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com
 




-- 
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com


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

Received on Tue Jul 26 2005 - 08:14:07 CDT