Home » SQL & PL/SQL » SQL & PL/SQL » UTL_SMTP Package
UTL_SMTP Package [message #265033] Wed, 05 September 2007 05:17 Go to next message
mai92457
Messages: 2
Registered: September 2007
Location: Saudi Arabia
Junior Member
Hell Dear,

I am trying to send email using UTL_SMTP package and receive error message as follows,
ORA-20001: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 83
ORA-06512: at "SYS.UTL_SMTP", line 356
ORA-06512: at "PRU_SEND_EMAIL", line 43
ORA-06512: at line 13

I am using Oralce 8.1.7SE on Windows platform. Any clue what may be cause of this error?

Hope a swift response.
Re: UTL_SMTP Package [message #265039 is a reply to message #265033] Wed, 05 September 2007 05:27 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

Are you using the correct email server name in the UTL_SMTP.OPEN_CONNECTION() call.

Ensure that there is SMTP server and the process is up and
running.

Cheers
Soumen
Re: UTL_SMTP Package [message #265041 is a reply to message #265039] Wed, 05 September 2007 05:32 Go to previous messageGo to next message
mai92457
Messages: 2
Registered: September 2007
Location: Saudi Arabia
Junior Member
Hi there,
I have SMTP client up and running. It was working all fine just after the change of hardware, DB was reinstalled and now this error message. Is there a way to verify the SMTP client presence.

Regards
Re: UTL_SMTP Package [message #265068 is a reply to message #265041] Wed, 05 September 2007 06:13 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

If your SMTP client is running file then check that you have correctly provide the ip address or name of the SMTP server.

Cheers
Soumen
Re: UTL_SMTP Package [message #268203 is a reply to message #265033] Mon, 17 September 2007 23:54 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

In addition password if authentication required.
Re: UTL_SMTP Package [message #269224 is a reply to message #265033] Fri, 21 September 2007 04:30 Go to previous messageGo to next message
a.bilal.shah
Messages: 10
Registered: June 2005
Junior Member
Have you run the UTL_SMTP.SQL in SYS user from
\rdbms\admin\ folder.

This will creat UTL_SMTP package.

Regards

AB
Re: UTL_SMTP Package [message #269226 is a reply to message #269224] Fri, 21 September 2007 04:50 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
How could he get an error, caused by the UTL_SMTP package if that package does not exist?
Re: UTL_SMTP Package [message #269370 is a reply to message #269226] Fri, 21 September 2007 17:11 Go to previous messageGo to next message
Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata
Senior Member

Frank wrote on Fri, 21 September 2007 10:50
How could he get an error, caused by the UTL_SMTP package if that package does not exist?


ha ha wrong question asked a.bilal.shah
Laughing

Cheers
Soumen
Re: UTL_SMTP Package [message #269402 is a reply to message #269370] Sat, 22 September 2007 01:21 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
No need to make fun of him/her.
Wrong message posted, Soumen! ./fa/1579/0/
Previous Topic: need to combine two tables
Next Topic: How to use UTL_FILE to export to flat file?
Goto Forum:
  


Current Time: Sat Dec 10 14:56:58 CST 2016

Total time taken to generate the page: 0.10984 seconds