Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Handling Data Conflicts > Custom Conflict Handlers

Custom Conflict Handlers

If the prebuilt update conflict handlers do not address your business requirements, you can write PL/SQL procedures that will act as the conflict handler. Such procedures are required to address conflicts from the INSERT and DELETE operations, as there are no prebuilt conflict handlers for those.

The procedure SET_DML_HANDLER in the DBMS_APPLY_ADM package is used to specify the conflict handler for a table. One or more custom conflict handlers can be defined for the same table. Table 10-2 lists the parameters of the SET_DML_HANDLER procedure.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint