Re: How to call a stored procedure from a stored function with parameter?

[William Chiquito]

Hi Zsolt,

My test:

DELIMITER $$

DROP PROCEDURE IF EXISTS `IsProductInForeignDatabase`$$

CREATE PROCEDURE `IsProductInForeignDatabase`(IN stock INTEGER(11), OUT MyResult VARCHAR(1000), IN Behaviour VARCHAR(20))
BEGIN
	IF LOWER(Behaviour) = 'question' THEN
		SET MyResult = '123 My Result';
	END IF;
END$$

DELIMITER ;

DELIMITER $$

DROP FUNCTION IF EXISTS `myfunc`$$

CREATE FUNCTION `myfunc`()
	RETURNS VARCHAR(1000)
BEGIN
	DECLARE MyResult VARCHAR(1000);
	CALL IsProductInForeignDatabase(1, MyResult, 'question');
	RETURN MyResult;
END$$

DELIMITER ;

SELECT myfunc();

Result:

myfunc()     
-------------
123 My Result