Member Avatar for cabsjonel

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 ;

  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.