1501: PROCEDURE DROP_MVIEW_TRIGGERS(mview_owner VARCHAR2, mview_name VARCHAR2) IS
1502: lv_sql varchar2(1000);
1503: begin
1504: for i in (SELECT trg.owner, trg.trigger_name 1505: FROM all_TRIGGERS TRG 1506: WHERE trg.table_owner = mview_owner and
1507: trg.table_name = mview_name
1508: )
1509: loop