OraFAQ Forum: Streams & AQ » UPDATE_CONFLICT

Home » Server Options » Streams & AQ » UPDATE_CONFLICT_HANDLER

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

UPDATE_CONFLICT_HANDLER [message #282939]

Sun, 25 November 2007 06:45

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.

Report message to a moderator