'Listening for changes in Oracle table to send rabbitMQ message and perform call to external API
I have Oracle database (version 19c) with table CHANGE_LOG. I have also a Java & spring application, lets call it CLIENT_APP. I need to perform some tasks from CLIENT_APP when something is inserted to CHANGE_LOG table: send message using RabbitMQ to external application APP_EXT, log that message was sent, call some another APP_EXT_2 to recalculate something based on id from CHANGE_LOG table.
Is there a way to listen for changes in Oracle DB (other than sending query in some time interval to search for new records)? Or maybe the only solution is to create Oracle trigger sending some notification to my CLIENT_APP to perform all required things? What is the best solution to perform such operations?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|