I need to get this MySQL stored proc working. I have omitted the guts and glory and gone right back to basics and even that won't frakin work
I am not by any stretch a MySQL developer so please be patient.
And I call it thusly
And it returns NULL
Why?
I am not by any stretch a MySQL developer so please be patient.
Code:
DELIMITER $$ DROP PROCEDURE IF EXISTS `myDB`.`getCurrentPeriodId` $$ CREATE PROCEDURE `myDB`.`getCurrentPeriodId` (OUT currentPeriodId INT) BEGIN SET currentPeriodId = 500; END $$ DELIMITER ;
Code:
CALL `myDB`.`getCurrentPeriodId`(@currentPeriodId); SELECT @currentPeriodId;
Why?
Comment