Home » SQL & PL/SQL » SQL & PL/SQL » got an error while sending mail from Oracle
got an error while sending mail from Oracle [message #41407] Mon, 30 December 2002 05:43 Go to next message
Leonard Sathish
Messages: 1
Registered: December 2002
Junior Member
Hi Guys & Gals
Wish U Happy New Year
i got an error while calling a procedure from asp.actually the procedure functionality is sending mail . the error follows...

Error Type:
OraOLEDB (0x80040E14)
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 374 ORA-06512: at "HCAP.MAILFROMDB", line 89 ORA-29278: SMTP transient error: 421 Service not available ORA-06512: at line 1

i've searched in this forum but i didn't get an answer
i hope i'll get an answer to my query...

thank u
with warm regards
leo
Re: got an error while sending mail from Oracle [message #41408 is a reply to message #41407] Mon, 30 December 2002 06:00 Go to previous message
Remi Visser
Messages: 44
Registered: December 2002
Member
Hi

It appears your mailserver is not up and running, or yuo've specified a wrong servername, port number:

...
21 mail_conn := UTL_SMTP.OPEN_CONNECTION( HOST => mail_host, PORT => mail_host_port);
22 UTL_SMTP.HELO( C => mail_conn, DOMAIN => mail_host);
...

Remi

Previous Topic: table creation
Next Topic: how to apply foreign key to the field of a nested table.
Goto Forum:
  


Current Time: Tue May 21 03:40:33 CDT 2024