Problem with UTL_SMTP

[Kenrae]

I'm using this package in order to send email messages, but when I send an email it multiplies it. What I mean is that I've sent one email to my account, and I've received twenty copies of the same email (and no, it isn't inside a loop). Does anybody know what is happening?

Thanks

 

[MikeJones]

I've not had this problem with SMTP, try connecting to the mailserver manually and doing all the things your code is doing in the same order. UTL_SMTP uses UTL_TCP which in turn sends basic TCP commands so I would expect a manual mail to send 20 emails as well.

Also are you checking the responses your commands are getting back from the mail server? Each command is overloaded as both a procedure and function. If you use the function version you can get the responses back and dbms_output them. you might be getting some warning messages back which just get ignored by Oracle.

HTH,

Mike.