SMTP error

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Tue, 26 Jul 2005 17:18:30 +0530
Message-ID: <a144e52105072604485cab4a78@mail.gmail.com>

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');
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:50:27 CDT