Prcedural replication issue

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Mahesh Hardikar

    Prcedural replication issue

    Hello ,
    Oracle 9.0.1.0.0 on HP-UX 11.11

    I am testing Procedural Replication in Multimaster Replication
    Environment. (Asynchronous)

    Package PACK_1 with a PROC_1 does insert in TAB_1. The procedure does
    a simple insert in tab_1.
    I mark PACK_1,PROC_1 for replication (Multimaster replication)

    After starting replication , I execute procedure

    execute proc_1 on Inst_1

    But somehow this execution is not captured by replication & hence does
    not fire on inst_2 which is second master site. I cannot see inserted
    row in second instance.

    AM I missing something ? I cld not find details on Procedural
    Replication in manual except saying procedures need to be part of
    package .

    The reason I am looking at Procedural Repl is that I have many tables
    which do not have primary key . So I cannnot use table level
    replication for those tables.

    Any help/pointers in this regad are highly appreciated ....

    Thanks & Regards,
    Mahesh Hardikar
Working...