Oracle7 Server Distributed Systems Volume II: Replicated Data

Conflict Notification

A conflict notification routine is a user-defined conflict resolution routine that provides notification, rather than resolution. You can have conflict information logged in a database view, or you can write a procedure that, for example, sends an e-mail message to the DBA (or dials a beeper).

You can set up notification to occur when you want it:

as soon as Oracle detects a conflict

before Oracle attempts a specific resolution routine

only if Oracle cannot resolve the conflict

Suggestion: To define the conflict notification routine(s) for your site, use the example

. Modify and/or expand upon the example with your own conflict resolution routines.

Note: If the conflict cannot ultimately be resolved, the entire transaction, including any updates to a notification table, will be rolled back. You can design your notification mechanism to use the Oracle DBMS_PIPES package or the interface to Oracle Office to ensure that notification occurs.