TRIGGER: OLAPSYS.CWM$CUBEDEL

Source

Description

olapsys.CwM$CubeDEL
  before delete on olapsys.CWM$CUBE 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$AWCubeLoad
      where Cube_IRID  = :old.irid
      and   Version_ID = 'CWM';
    delete from olapsys.CwM2$AWCompositeSpec
      where Cube_IRID  = :old.irid
      and   Version_ID = 'CWM';
    delete from olapsys.CwM2$AWCubeAgg
      where Cube_IRID  = :old.irid
      and   Version_ID = 'CWM';
 end;