Home » Server Options » Streams & AQ » UPDATE_CONFLICT_HANDLER
UPDATE_CONFLICT_HANDLER [message #282939] Sun, 25 November 2007 06:45 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
DECLARE
cols DBMS_UTILITY.NAME_ARRAY;
BEGIN
cols(1) := 'a';
cols(2) := 'b';
DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER(
object_name => 'sadat.test2',
method_name => 'OVERWRITE',
resolution_column => 'a',
column_list => cols);
END;
/

Is there any procedure by which I can set handler for all objects for a schema???


thanx.
Re: UPDATE_CONFLICT_HANDLER [message #283093 is a reply to message #282939] Mon, 26 November 2007 01:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I think it is not possible.
Re: UPDATE_CONFLICT_HANDLER [message #283103 is a reply to message #282939] Mon, 26 November 2007 02:12 Go to previous message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
I appreciate ur thinking.
Previous Topic: downstream replication problem
Next Topic: Remove apply rule
Goto Forum:
  


Current Time: Thu Mar 28 09:19:54 CDT 2024