Home » SQL & PL/SQL » SQL & PL/SQL » UTL_SMTP & Mailing Issue (merged) (Oracle 10G R2 / AIX Inix)
icon9.gif  UTL_SMTP & Mailing Issue (merged) [message #426191] Wed, 14 October 2009 06:06 Go to next message
sreekanth.nair
Messages: 5
Registered: October 2009
Junior Member
I have used UTL_SMTP to send mails. Our OS is AIX Unix.
I have used following exceptions in my procedure

WHEN UTL_SMTP.INVALID_OPERATION THEN
pkg_log.p_log_message(v_module,'10.1 Invalid Operation When Sending Mail');
UTL_SMTP.quit (v_mail_con);
RAISE;

WHEN UTL_SMTP.TRANSIENT_ERROR THEN
pkg_log.p_log_message(v_module,'10.2 Temporary e-mail issue');

WHEN UTL_SMTP.PERMANENT_ERROR THEN
pkg_log.p_log_message(v_module,'10.2 Permanent Error Encountered While Sending Mail');


Now how to make a code which will raise an error even if the mail id is wrong [abc@gmaaail.com[/email]].
To make it clear we used to get return error like mail box full/ not exist etc.. is it possible to do it thru Oracle?
Re: UTL_SMTP & Mailing Issue [message #426194 is a reply to message #426191] Wed, 14 October 2009 06:11 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
To the best of my knowledge, no.
Oracle supports a SMTP server to send mails from, but you'd need a POP server of some description to handle incoming email, and I don't know of one that runs in an oracle database.
Re: UTL_SMTP & Mailing Issue [message #426196 is a reply to message #426191] Wed, 14 October 2009 06:33 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I think the SMTP server you are trying to send your mail through might return an error-code, indicating what went wrong.
Re: UTL_SMTP & Mailing Issue [message #426200 is a reply to message #426191] Wed, 14 October 2009 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not possible.

Regards
Michel
icon9.gif  Re: UTL_SMTP & Mailing Issue [message #426201 is a reply to message #426196] Wed, 14 October 2009 06:44 Go to previous message
sreekanth.nair
Messages: 5
Registered: October 2009
Junior Member
Hi All,
Thanks for swift replys...
SMTP error codes handles any error like '@' is not there in the mail etc. But as JRowbottom indicated SMTP may not handle those issues which occur at the receiving end say at gmail server end like no space in receivers mail box or mentioned email address in not present in gmail etc.....

Thanks & Regards,
Sree
Previous Topic: SQL PROBLEM FOR MERGING THE RECORD
Next Topic: Explain Plan in pl/sql
Goto Forum:
  


Current Time: Sun Dec 11 08:11:21 CST 2016

Total time taken to generate the page: 0.10355 seconds