BEGIN UPDATE SUPERMAG.SMPOSTQUEUE SET VIRTPACK = NULL WHERE VIRTPACK = :virtpack; DELETE FROM (SELECT A.* FROM SUPERMAG.SMPOSTFAILRP A, SUPERMAG.SMPOSTPACKAGES S WHERE A.FPID = S.ID AND S.VIRTPACK = TO_NUMBER(:virtpack)); DELETE FROM SMPOSTPACKAGES WHERE VIRTPACK = TO_NUMBER(:virtpack); DELETE FROM SMPOSTVIRTPACKS WHERE ID = TO_NUMBER(:virtpack); COMMIT; END;
delete from smpostpackages where uploadfailed=0 and deliveryack is not null; commit; delete from smpostfailrp; commit; update smpostpackages set uploadfailed=0, deliveryack=null, laststarted=null where uploadfailed=1; commit;