Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\createTriggers.sql

CREATE OR REPLACE TRIGGER DMLFCOTRIGGER AFTER DELETE

ON CMPFCOClasses FOR EACH ROW
BEGIN
  insert into changeLog(workspaceID, elementid, action) values(:old.workspaceID,:old.i_1,1);
EXCEPTION
  when DUP_VAL_ON_INDEX then
    update changeLog set action = 1
    where elementid = :old.i_1;
END;
/
alter trigger dmlFCOtrigger disable;

CREATE OR REPLACE TRIGGER DMLSCOTRIGGER AFTER DELETE

ON CMPSCOClasses FOR EACH ROW
BEGIN
  insert into changeLog(workspaceID, elementid, action) values(:old.workspaceID,:old.i_1,1);
EXCEPTION
  when DUP_VAL_ON_INDEX then
    update changeLog set action = 1
    where elementid = :old.i_1;
END;
/
alter trigger dmlSCOtrigger disable;

CREATE OR REPLACE TRIGGER DMLSCOCfgTRIGGER AFTER DELETE

ON CMPSCOCfgClasses FOR EACH ROW
BEGIN
  insert into changeLog(workspaceID, elementid, action) values(:old.workspaceID,:old.i_1,1);
EXCEPTION
  when DUP_VAL_ON_INDEX then
    update changeLog set action = 1
    where elementid = :old.i_1;
END;
/
alter trigger dmlSCOCfgtrigger disable;

CREATE OR REPLACE TRIGGER DMLSCOMapTRIGGER AFTER DELETE

ON CMPSCOMapClasses FOR EACH ROW
BEGIN
  insert into changeLog(workspaceID, elementid, action) values(:old.workspaceID,:old.i_1,1);
EXCEPTION
  when DUP_VAL_ON_INDEX then
    update changeLog set action = 1
    where elementid = :old.i_1;
END;
/
alter trigger dmlSCOMaptrigger disable;

CREATE OR REPLACE TRIGGER DMLSCOPrpTRIGGER AFTER DELETE

ON CMPSCOPrpClasses FOR EACH ROW
BEGIN
  insert into changeLog(workspaceID, elementid, action) values(:old.workspaceID,:old.i_1,1);
EXCEPTION
  when DUP_VAL_ON_INDEX then
    update changeLog set action = 1
    where elementid = :old.i_1;
END;
/
alter trigger dmlSCOPrptrigger disable;

CREATE OR REPLACE TRIGGER DMLSYSTRIGGER AFTER DELETE

ON CMPSYSClasses FOR EACH ROW
BEGIN
  insert into changeLog(workspaceID, elementid, action) values(:old.workspaceID,:old.i_1,1);
EXCEPTION
  when DUP_VAL_ON_INDEX then
    update changeLog set action = 1
    where elementid = :old.i_1;
END;
/
alter trigger dmlSYStrigger disable;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de