Something

DELIMITER $$

DROP PROCEDURE IF EXISTS `progressive`.`item_insert` $$
CREATE PROCEDURE `progressive`.`item_insert` (item_id int(11))
BEGIN
		DECLARE cur1 CURSOR FOR SELECT store_id from progressive.store;
		OPEN cur1;
		REPEAT	
		FETCH cur1 INTO a;
    			INSERT INTO inventory SET inventory.store_id = a, inventory.item_id = item_id, inventory.created_date=now(), inventory.modified_date=now();
		UNTIL done END REPEAT;
		CLOSE cur1;
END $$

DELIMITER ;



give errror:
undeclared variable a