Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Custom E-Mail-Notification on data changes

4043860Jul 15 2019 — edited Jul 16 2019

I want to develop a component which send E-Mail-Notifications when a specific or unspecific record has changed.

I want the user to select a table and maybe a specific column or row. Then I want to notify the user when something from his selection changed.

I use a Oracle 12g Database.

Is there a common way to achieve this?

Thanks in advance.

I already tried the following techniques:

- Oracle Continuous Query Notification

- Oracle Change Data Capture

- Oracle Triggers

Example:

1. The user "subscribes" the table "customer" and the column "street".

2. When a value in the column "street" ist updated, inserted or deleted, the user receives an E-Mail.

This post has been answered by John Thorton on Jul 15 2019

Jump to Answer

Added on Jul 15 2019

#email, #general-database-discussions, #notification, #oracle

3 comments

219 views