Executing the following SP the OUT param does not have the correct value. It does work from the 'Command Line Client',
DELIMITER $$
DROP PROCEDURE IF EXISTS `foo`.`fetchTargetID` $$
CREATE PROCEDURE `fetchTargetID`(IN param CHAR(45), OUT t_out INT)
BEGIN
SELECT Target INTO t_out FROM USER WHERE NAME LIKE param;
END $$
DELIMITER ;
Is there a setting or something like this?
Thank you so much!
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --