RE: SMTP error

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 26 Jul 2005 07:53:11 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FA83@EXCNYSM0A1AJ.nysemail.nyenet>

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',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');
  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
 


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

Received on Tue Jul 26 2005 - 06:55:09 CDT