zim32 / mysql.dart

MySQL client for Dart written in Dart
BSD 3-Clause "New" or "Revised" License
64 stars 17 forks source link

Unable to execute store procedure #34

Open leamlidara opened 1 year ago

leamlidara commented 1 year ago

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 commented 1 year ago

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 ;