Since SQLcl has Nashorn, now it can be integrated with a few lines of javascript to get notified when changes happen. The script is below and posted. The catch is QCN only works on Varchars and Numbers.
Thursday, June 16, 2016
SQLcl and Query Change Notification
The database has had Query Change Notification for a while but to use it required a custom program. Such as Tim outlines on his blog https://oracle-base.com/articles/10g/dbms_change_notification_10gR2
Since SQLcl has Nashorn, now it can be integrated with a few lines of javascript to get notified when changes happen. The script is below and posted. The catch is QCN only works on Varchars and Numbers.
Since SQLcl has Nashorn, now it can be integrated with a few lines of javascript to get notified when changes happen. The script is below and posted. The catch is QCN only works on Varchars and Numbers.
