My table two user operate on the same record.
The first user is reading.The second user is reading,but second user is data changing.
How to alert first user when the update?
Data Change Alert
Re: Data Change Alert
hello,
To implement notification of users about changes in tables, you can use the TOraChangeNotification components. The sample of using this component is in the demo projects folder.
To implement notification of users about changes in tables, you can use the TOraChangeNotification components. The sample of using this component is in the demo projects folder.
Re: Data Change Alert
Demo project in ChangeNotification is exception.
Exception message:Change notification is not support in Direct mode.
Do not have any other way?
Exception message:Change notification is not support in Direct mode.
Do not have any other way?
Re: Data Change Alert
hello,
As we use the OCI callback function for implementation of notification, this functionality is unavailable in Direct mode. You can implement the notification gear by means of the PL/SQL stored procedure. You can find more details at the Oracle site http://docs.oracle.com/cd/B19306_01/appdev.102/b14251/adfns_dcn.htm
As we use the OCI callback function for implementation of notification, this functionality is unavailable in Direct mode. You can implement the notification gear by means of the PL/SQL stored procedure. You can find more details at the Oracle site http://docs.oracle.com/cd/B19306_01/appdev.102/b14251/adfns_dcn.htm