Skip to main content
  • EN

 

I want to instantly receive a notification email when a new record has been added to a table that is in Oracle

Hi @joeroses

I suggest you to use the transformer FeatureWriter to update attributes and after the transformer Emailer.

 

Thanks,

 

Danilo

If the table is updated with something non-FME and it's urgent that you get the notification, one of the better solutions is probably to write an Oracle trigger on that table that can notify FME Server using the REST API, which in turn could send the email.

Maybe it's even possible to send an email directly from an Oracle trigger? Hmmm

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:7267435205059

Hi @joeroses

I suggest you to use the transformer FeatureWriter to update attributes and after the transformer Emailer.

 

Thanks,

 

Danilo

Thanks a lot

Thanks a lot

You are welcome :)

If the table is updated with something non-FME and it's urgent that you get the notification, one of the better solutions is probably to write an Oracle trigger on that table that can notify FME Server using the REST API, which in turn could send the email.

Maybe it's even possible to send an email directly from an Oracle trigger? Hmmm

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:7267435205059

Thank you very much

Reply


Community Stats

30,352
Posts
115,344
Replies
38,087
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.