Home » SQL & PL/SQL » SQL & PL/SQL » Log All Mails Send by Database Server Using UTL_SMTP (Oracle 10g PL/SQL)
icon1.gif  Log All Mails Send by Database Server Using UTL_SMTP [message #344174] Fri, 29 August 2008 00:31 Go to next message
gaganzk
Messages: 36
Registered: May 2008
Member
Hi All,

I am Using Oracle 10g and I use pl/sql Code(UTL_SMTP) to send mails.Sometimes i did not receive the mails From my database server even no error occurred from database part.So i want to keep log of all the mails send by Database Server .Is it Possible?


Regards:
Gagan Deep Kaushal

[Updated on: Fri, 29 August 2008 00:32]

Report message to a moderator

Re: Log All Mails Send by Database Server Using UTL_SMTP [message #344176 is a reply to message #344174] Fri, 29 August 2008 00:35 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>.So i want to keep log of all the mails send by Database Server .Is it Possible?

yes. log to a table.
Re: Log All Mails Send by Database Server Using UTL_SMTP [message #344528 is a reply to message #344174] Sat, 30 August 2008 03:58 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Wild guess: Start by removing the WHEN OTHERS part from your procedure..
If you plan on logging your mails, you might just as well not send them at all. After all, apparently you don't trust the mailing capabilities of your system.
Previous Topic: selecting max five sal from a table
Next Topic: strange to_char result.
Goto Forum:
  


Current Time: Fri Dec 09 07:50:08 CST 2016

Total time taken to generate the page: 0.06604 seconds