Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » to send email from workflow???
to send email from workflow??? [message #109832] Tue, 01 March 2005 05:12 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10707
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.
Previous Topic: to create workflow process which examine any database table.
Next Topic: Tracking
Goto Forum:
  


Current Time: Thu Mar 28 15:41:34 CDT 2024