SMTP error

  • From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 26 Jul 2005 17:18:30 +0530

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@xxxxxxxxxxx');
7 UTL_SMTP.RCPT(v_connection,'moqthiyar@xxxxxxxxx');
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@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx

Other related posts: