11/30/06 18:43 Error: Unexpected Oracle error: ORA-06550: line 33, column 1:.PLS-00306: wrong number or types of arguments in call to 'CR_AMS_CREDITS'.ORA-06550: line 33, column 1:.PL/SQL: Statement ignored. (object name: "ECOMM"."AMS_CREDITS") [sp_opst (for o.data-o.data queue eos)/1727]
CR procedure is created with basic CR interface and SP_OPO_GENERIC_CR is set to 1 which tells shareplex it is generic CR interface.
1. sp_ctrl> stop post
2. sp_ctrl> set param SP_OPO_GENERIC_CR 0
3. sp_ctrl> start post
A value of 0 (this is the default value) tells shareplex the procedure is created using basic conflict resolution interface and use the corresponding code.
A value of 1 tells shareplex the procedure is created using generic conflict resolution interface.
Generic CR looks like this in parameter declarations:
<example>
CREATE OR REPLACE PROCEDURE owner.procedure_name (
table_info IN OUT owner.sp_cr.row_typ,
col_values IN owner.sp_cr.col_def_tabtyp
)
IS
.....
Basic CR looks like this in parameter declarations:
< Update CR example>:
create or replace procedure owner.procedure_name (
new owner.table_name%ROWTYPE,
old owner.table_name%ROWTYPE,
key owner.table_name%ROWTYPE,
ret_code NUMBER,
ora_sid VARCHAR2,
src_host VARCHAR2,
src_ora_time VARCHAR2,
status OUT NUMBER)
......
Please also review the 'Establishing Peer to Peer Replication' section in Shareplex Admin Guide for more information on Basic Conflict Resolution and Generic Conflict Resolution.
Note: Basic Conflict Resolution will be deprecated in future shareplex versions, the best practice is to use Generic Conflict Resolution which utilizes dynamic PL/SQL code.
