CREATE OR REPLACE TRIGGER track_delete_trigger BEFORE DELETE ON ic03jc.album REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE oldalbumid NUMBER := old.dbalbumid; BEGIN DELETE FROM ic03jc.album_track WHERE dbalbumid = oldalbumid; END;