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 Received on Thu Sep 11 2003 - 13:46:29 CEST