Use of Oracle Advanced Queuing to receive changes of database table rows

287 views Asked by At

I am confused about Oracle Advanced Queueing. It looks like it is a way to asynchronously send database notification to application layer. But looking in some details, there is queue to be setup, alongside a table. and there is explicit calls to publish messages that will afterward be pushed to the application layer.

Does this work automatically with table rows modification ? I want, if a particular table changes (no matter who/how changed), to receive a notification about it in form of a binary object that represents the row changed.

(Note: I know about Oracle Query change notification, CQN, but I am not satisfied with its performance, my goal is then to see if Oracle Advanced Queue can offer similar goal with better speed).

Thanks in advance.

0

There are 0 answers