| Procedural replication [message #366504] |
Thu, 13 January 2000 15:28 |
VLN Rao
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
