| email trigger [message #55628] |
Wed, 05 February 2003 11:02  |
victor rodriguez
Messages: 6
Registered: December 2002
|
Junior Member |
|
|
Does anybody know of a way to write a trigger in Oracle in order to get notified via email when somebody performs DML on an Oracle table?
Thanks.
|
|
|
|
| Re: email trigger [message #55640 is a reply to message #55628] |
Thu, 06 February 2003 01:58  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You have to write AFTER UPDATE/INSERT/DELETE trigger. Inside the trigger call a PL/SQL stored procedure to e-mail you whatever message you want. Sample code for sending e-mails from PL/SQL could be found Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
