TRIGGER: ODM.ODM_MINING_MODEL_TRIGGER

Source

Description

odm_mining_model_trigger
AFTER DELETE ON odm_mining_model
FOR EACH ROW

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
  PRAGMA AUTONOMOUS_TRANSACTION;
  v_cnt  NUMBER;
BEGIN
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE '|| :old.table_1;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE '|| :old.table_2;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE '|| :old.table_3;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE '|| :old.table_4;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE '|| :old.table_5;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE '|| :old.table_6;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE '|| :old.table_7;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    SELECT COUNT(*) INTO v_cnt
      FROM odm_mining_model
      WHERE bin_numerical_table = :old.bin_numerical_table;
    IF v_cnt = 1 THEN
      EXECUTE IMMEDIATE 'DROP TABLE '|| :old.bin_numerical_table;
    END IF;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
  BEGIN
    SELECT COUNT(*) INTO v_cnt
      FROM odm_mining_model
      WHERE bin_categorical_table = :old.bin_categorical_table;
    IF v_cnt = 1 THEN
      EXECUTE IMMEDIATE 'DROP TABLE '|| :old.bin_categorical_table;
    END IF;
  EXCEPTION
    WHEN OTHERS THEN
      NULL;
  END;
EXCEPTION
  WHEN OTHERS THEN
    NULL;
END;