| to send email from workflow??? [message #109832] |
Tue, 01 March 2005 05:12  |
manish_singla
Messages: 5
Registered: February 2005
|
Junior Member |
|
|
suppose i hav a table in pl/sql having columns as :---
name
email
flag
now i want to create a new w/f that monitors this table in pl/sql and if a column in the table changes (let it be flag....i.e. if it changes to Y TO N) then it sends an email at corsponding address.
then the process repeats after some specific time.
how can we do it???
i really appreciated the help.
|
|
|
|
| Re: to send email from workflow??? [message #109865 is a reply to message #109832] |
Tue, 01 March 2005 09:49  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
the simplest possible method ( may be NOT the efficient) would be
1. create a procedure to send email ( using UTL_SMTP)
2. create a trigger on the base table which fires after insert or update on the column FLAG.
Every time there is an update / change in the table this trigger fires and calls the send_email prcodure created above.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
