OraFAQ Forum: SQL & PL/SQL » Log All Mails Send by Database Server Using UTL

Home » SQL & PL/SQL » SQL & PL/SQL » Log All Mails Send by Database Server Using UTL_SMTP (Oracle 10g PL/SQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Log All Mails Send by Database Server Using UTL_SMTP [message #344174]

Fri, 29 August 2008 00:31

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

BlackSwan
Messages: 26766
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.

Report message to a moderator

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

Frank
Messages: 7901
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.

Report message to a moderator

Previous Topic:	selecting max five sal from a table
Next Topic:	strange to_char result.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 01:07:09 CST 2024