hello guys thank you for reading my post , guys do you know how
to call stored procedure with out parameter in visual basic?
hers my sample code but it is error
Cmd.CommandType = adCmdStoredProc
Cmd.CommandText = "proc1"
Cmd.Paramters.Append Cmd.CreateParameter("@a", adVarWChar, adParamOutput, 255)
Cmd.Execute
my stored procedure
DELIMITER $$
DROP PROCEDURE IF EXISTS `lending`.`proc1` $$
CREATE PROCEDURE `lending`.`proc1` (out a integer)
BEGIN
set a = 1;
END $$
DELIMITER ;
