how to generate an email on a database event?
Dear gurus...I've heard about diferent ways of generating email in response to a database event e.g
1 - Using UTL_MAIL package
or
2 - Event Driven Reporting feature of 10g Database and using SRW.Run_Report package to generate and mail a report.
Now I'm confused that how should I accomplish the following tasks:
(i) - How to generate an email after Insert/Update/Delete on a table and acknowledge the concerned users about that event?
(ii) - How to attach a text file with that email?