CREATE OR REPLACE PACKAGE pkg IS
   TYPE tip_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
   tip_tab     tip_tab_type;
   tip_index   BINARY_INTEGER;
END pkg;

CREATE OR REPLACE TRIGGER TRG_01_BEF_STM
  BEFORE DELETE ON ordrespec
BEGIN
  pkg.tip_index := 0;
END;
/

CREATE OR REPLACE TRIGGER TRG_02_AFT_ROW
  AFTER DELETE ON ordrespec
  FOR EACH ROW
BEGIN
  pkg.tip_index := pkg.tip_index + 1;
  pkg.tip_tab(pkg.tip_index) := :OLD.ordrenr;
END;
/

CREATE OR REPLACE TRIGGER TRG_03_AFT_STM
  AFTER DELETE ON ordrespec
DECLARE
  cnt NUMBER;		
BEGIN
  FOR i IN 1 .. pkg.tip_index LOOP
    SELECT COUNT(*) INTO cnt 
      FROM ordrespec
      WHERE ordrenr = pkg.tip_tab(i);

    IF cnt = 0 THEN
       DELETE FROM ordre WHERE ordrenr = pkg.tip_tab(i);
    END IF;						
  END LOOP;
  pkg.tip_index := 0;
END;
/

DELETE FROM ordrespec WHERE ordrenr = some_value;