I am trying to write a function for notification when a conflict occurs in a master-master replication setup. This function basically inserts all the column values that had conflicts into a table. For this, I have to write a user defined conflict resolution routine. In the examples given in Oracle documentation, it looks like we have to write one function for each table involved in replication. And, if all the columns of a table are involved in a column group, then, the input to the conflict resolution functions (eg unique conflicts) will be all the columns SORTED in alphabetic order.

I am sure I must be missing something here. This is SO cumbersome to do and maintain. Is there a simpler way ? Can I write a common function and call it for conflict notification of all the tables ? The problem I see is the difference in the number of columns for each table.

Please help and save me hours of work.

Thanks
Neelima