DROP TABLE IF EXISTS otl;
create table otl (
qty numeric(11,2),
d datetime,
deal numeric (9,0));

DROP  PROCEDURE IF EXISTS demo;
CREATE PROCEDURE demo()
BEGIN
  DECLARE done, done2 INT DEFAULT FALSE;
  declare vqty numeric(11,2);
  declare vd datetime;
  declare vdeal numeric (9,0)  ;
  
  DECLARE cur1 CURSOR FOR SELECT deal, sum(qty) FROM otl having sum(qty)>0;
  DECLARE cur2 CURSOR FOR SELECT d FROM otl where deal = vdeal;
  
  OPEN cur1;
  SET done = 0;
  FETCH cur1 INTO  vDeal, vQty ;
  WHILE NOT done DO 
  
        OPEN cur2;
        SET done2 = 0;
        FETCH cur2 INTO  vd ;
        WHILE NOT done2 DO 
          IF vd<now() THEN
            /*действие 1 и выход из этого курсора*/
            SET done2 = 1;              
          ELSE
            /*действие 2*/
            SET done2 = 0;   
          END IF;
        FETCH cur2 INTO  vd ;
        END WHILE;
        CLOSE cur2;
                     
      SET done = 0;
      FETCH cur1 INTO  vDeal, vQty ;
  END WHILE;
  CLOSE cur1;        
END;

DECLARE done, done2 INT DEFAULT 0;

  DECLARE done, done2 INT DEFAULT 0;
  DECLARE cur1 CURSOR FOR SELECT deal, sum(qty) FROM otl having sum(qty)>0;
  DECLARE cur2 CURSOR FOR SELECT d FROM otl where deal = vdeal;
  DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done=1;

  OPEN cur1;
  FETCH cur1 INTO  vDeal, vQty ;
  WHILE NOT done DO   
        
        OPEN cur2;
        SET done2 = 0;
        FETCH cur2 INTO  vd ;
        WHILE NOT done2 DO 
          IF vd<now() THEN
            /*действие 1 и выход из этого курсора*/
            SET done2 = 1;              
          ELSE
            /*действие 2*/
            SET done2 = 0;   
          END IF;
        FETCH cur2 INTO  vd ;
        END WHILE;
        CLOSE cur2;
        
      FETCH cur1 INTO  vDeal, vQty ;
  END WHILE;
  CLOSE cur1;        
END;