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 ;

I consider you are asking about OUT parameter.

Please go through this sample code.

That code is written for Oracle, but VB part remains same.