delimiter //
CREATE procedure catalog_by_prod (IN product TINYTEXT, OUT catalog TINYTEXT)
SELECT `cat_name` INTO catalog FROM `products` JOIN `catalog` USING (`id_cat`)
WHERE `prod_name`= product; //
delimiter ;

CALL catalog_by_prod ('Celeron D 320 2.4GHz', @catalog);
select  @catalog;

delimiter //
CREATE procedure catalog_by_prod (IN product TINYTEXT, OUT id_cat INT, OUT catalog TINYTEXT)
SELECT `id_cat`, `cat_name` INTO catalog FROM `products` JOIN `catalog` USING (`id_cat`)
WHERE `prod_name`= product; //
delimiter ;

CALL catalog_by_prod ('D 320 2.4GHz', @id, @catalog);
select @id, @catalog;

SELECT `id_cat` INTO id_cat, `cat_name` INTO catalog FROM `products` JOIN `catalog` USING (`id_cat`)
WHERE `prod_name`= product;

CREATE procedure catalog_by_prod (IN product TINYTEXT, OUT id_cat INT, OUT catalog TINYTEXT)
BEGIN
DECLARE product TINYINT;
DECLARE id_cat INT;
DECLARE catalog TINYINT;
DECLARE is_end INT DEFAULT 0;
DECLARE curcat CURSOR FOR SELECT `id_cat`, `cat_name` FROM `products` JOIN `catalog` using (`id_cat`) WHERE `prod_name`=product;
DECLARE  CONTINUE HANDLER FOR NOT FOUND SET is_end=1;
OPEN curcat;
wet: LOOP
FETCH curcat INTO id_cat, catalog;
IF is_end THEN LEAVE wet;
END IF;
END LOOP wet;
CLOSE curcat;
END//

CALL catalog_by_prod ('Celeron D 320 2.4GHz', @id, @catalog);
select @id, @catalog;