Home » Server Options » Replication » Procedural replication
Procedural replication [message #366504] Thu, 13 January 2000 15:28
Messages: 1
Registered: January 2000
Junior Member
Environment :
Sun Sol 5.6
Oracle v7.3.4.4
Three site multi-master replication system

Problem description : I created a master group MG1 at a mas def site A. And replicated across to master sites B & C. Master group MG1 contains only one package AUDIT_POSTINGS with only one procedure AUDIT_TRAN in it(has one argument). Generted the replication support for the package and its package body with a wrapper DEFER_AUDIT_POSTINGS. All sites A, B & C has the wrapper package and package body generated and are with valid status.

I have two problems :
Question-1: If I execute AUDIT_POSINTS.AUDIT_TRAN(1233). This gets executed. Data inserted ok. But no DefCall's generated and hence no effect on other sites.
What is the problem?

Questions-2: If I execute DEFER_AUDIT_POSINTS.AUDIT_TRAN(tranid =>1233, call_local => 'Y', call_remote => 'Y); it says invalid number of arguments. I tried AUDIT_POSTINGS(tranid => 1233, call_local => 'Y', call_remote => 'Y); Same problem. What it that I am missing. No oracle manual gives me sufficient information in this regard.

Please help...
Previous Topic: Multimaster Replication error
Next Topic: replicating - ommitting set of deletes
Goto Forum:

Current Time: Sat May 21 14:17:49 CDT 2022