I want to use POST_EVENT in my database to monitor changes in a table.
Suppose I have a Table with fields STOCK_ID (generator value) and
STOCK_PRICE. I want my application to respond when the stock price is
changed. I intend to do this with a POST_EVENT inside an UPDATE Trigger.
But, if my application is only viewing a few stocks, then, the
application should be able to discern if the POST_EVENT was raised by
a change in STOCK_PRICE of the stocks it is viewing. My question is,
how do I inform the application as to which record was modified? I
suspect I could do this using
POST_EVENT event;
where event variable = STOCK_ID
However, my database has several tables with _ID fields that I want to
monitor and the generator values may be identical.