TRIGGER: OLAPSYS.CWM$LEVELDEL

Source

Description

olapsys.CwM$LevelDEL
  before delete on olapsys.CwM$Level for each row
  

Type

BEFORE EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare
  begin
    delete  from olapsys.CwM2$AWCubeAggLevel
      where IRID in (select  cal.IRID
                       from  CwM2$AWCubeAgg ca
                            ,CwM2$AWCubeAggLevel cal
                       where ca.IRID        = cal.CubeAgg_IRID
                       and   ca.Version_ID  = 'CWM'
                       and   cal.Level_IRID = :old.irid);
  end;