How can i capture data change of one table in oracle and post changed information to one web service intermediately

192 Views Asked by At

I have an account table in oracle, in this table has balance column, how can i capture a change of this column and post new value to one endpoint ws intermediately Thanks a lot

1

There are 1 best solutions below

0
Swaminathan K On

Have you tried doing this with an AFTER UPDATE TRIGGER? Oracle has a UTL_HTTP package which you can use within the trigger to make a webservice call.

The code here can be a good starting point