tailieunhanh - Oracle Built−in Packages- P137

Oracle Built−in Packages- P137: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk REGION_ID1_n REGION_NAME2_o REGION_NAME2_n site_name propagation_flag then raise end if exception when others then raise end when dup_val_on_index then begin if not REGION RR .unique_conflict_update_handler REGION_ID1_o REGION_ID1_n REGION_NAME2_o REGION_NAME2_n site_name propagation_flag SQLERRM then raise end if exception when others then raise end when others then raise end rep_update end REGION RP As you can see Oracle invokes REGION RR the conflict resolution package package body REGION RR as function unique_conflict_insert_handler REGION_ID1_n IN NUMBER REGION_NAME2_n IN VARCHAR2 site_name IN VARCHAR2 propagation_flag IN CHAR errmsg IN VARCHAR2 return boolean is begin return FALSE end unique_conflict_insert_handler function delete_conflict_handler REGION_ID1_o IN NUMBER REGION_NAME2_o IN VARCHAR2 site_name IN VARCHAR2 propagation_flag IN CHAR return boolean is begin return FALSE end delete_conflict_handler function update_conflict_handler REGION_ID1_o IN NUMBER REGION_ID1_n IN NUMBER REGION_NAME2_o IN VARCHAR2 REGION_NAME2_n IN VARCHAR2 Replication Support with DBMS_REPCAT 671 Appendix A What s on the Companion Disk site_name IN VARCHAR2 propagation_flag IN CHAR return boolean is begin return FALSE end update_conflict_handler function unique_conflict_update_handler REGION_ID1_o IN NUMBER REGION_ID1_n IN NUMBER REGION_NAME2_o IN VARCHAR2 REGION_NAME2_n IN VARCHAR2 site_name IN VARCHAR2 propagation_flag IN CHAR errmsg IN VARCHAR2 return boolean is begin return FALSE end unique_conflict_update_handler end REGION RR This is the default conflict handling package that GENERATE_REPLICATION_SUPPORT creates. Since no conflict resolution methods are defined for REGION the unique_conflict_insert_handler delete_conflict_handler update_conflict_handler and .