Error when calling stored procedure with out parameter in ASP classic
I'm trying to call a MySQL stored procedure and read its out parameter using ASP classic. Unfortunately I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-5.5.5-10.3.17-MariaDB]OUT or INOUT argument 2 for routine baseline.Proc_Test is not a variable or NEW pseudo-variable in BEFORE trigger
/functions/command_procedure.asp, line 54
The stored procedure is defined here:
DELIMITER //CREATE PROCEDURE Proc_Test (IN Lang_param VARCHAR(10), OUT ID_param int)BEGIN SET ID_param = 99;END //DELIMITER ;CALL Proc_Test ('eS', @myID);SELECT @myID;