mysql.dart icon indicating copy to clipboard operation
mysql.dart copied to clipboard

Unable to execute store procedure

Open leamlidara opened this issue 2 years ago • 1 comments

I have a store procedure which call some complex functions or other store procedure inside it. but unfortunately, it cannot be execute using this package.

leamlidara avatar Jul 28 '22 06:07 leamlidara

Here is my sample store procedure.

DELIMITER //
DROP PROCEDURE IF EXISTS `spGetUser`//
CREATE PROCEDURE `spGetUser` (_userId INT(11) UNSIGNED)
BEGIN
	SELECT user_id, email, full_name, register_date FROM tbl_user WHERE user_id=_userId LIMIT 1;
END //
DELIMITER ;

leamlidara avatar Jul 28 '22 06:07 leamlidara