/* Script to disable the XLIFF 1.2 filter */ DECLARE tcount INTEGER; BEGIN SELECT count(filterInfoId) INTO tcount FROM mediaTypes WHERE filterInfoId = 72; IF (nvl(tcount, 0) = 1) THEN dbms_output.put_line('---> Deleting the usages of XLIFF 1.2 File Type'); DELETE FROM mediaTypeMappings where mediaTypeId = 46; DELETE FROM filterGroupEntries WHERE mediaTypeId = 46; DELETE FROM mediaTypes where mediaTypeId = 46 and filterInfoId = 72; END IF; SELECT count(filterInfoId) INTO tcount FROM filterInfos WHERE name LIKE 'XLIFF 1.2 File Type' AND filterInfoId = 72; IF (nvl(tcount, 0) = 1) THEN dbms_output.put_line('-->Disabling XLIFF 1.2 filter'); DELETE FROM filterInfos WHERE name LIKE 'XLIFF 1.2 File Type' AND filterInfoId = 72; DELETE FROM fileTypeInformation WHERE filterName = 'XLIFF 1.2 File Type'; ELSE dbms_output.put_line('-->XLIFF 1.2 filter already disabled'); END IF; END; / commit;