I want to instantly receive a notification email when a new record has been added to a table that is in Oracle
Question
How can I send a notification by mail at the exact moment a table is updated in Oracle?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+52- Celebrity
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
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