mysql.dart
mysql.dart copied to clipboard
Unable to execute store procedure
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.
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 ;