Problem with call procedure

pdusp posted 5 months ago in General

Hello! My HeidiSQL can't run stored procedure. It has one input and one output param, but Heidi asks for both and finally reports error. Thank you Piotr

3 attachment(s):
  • call1
  • call2
  • call3
Misha v.3 posted 5 months ago

INOUT & OUT params should be variable or SQL will not be able to write in it. So you have to do something like this:

SET @a = 2; -- for INOUT
CALL myproc(1, @a);
pdusp posted 5 months ago

Please tell why HeidiSQL asked me for parameters which is only OUT?

1 attachment(s):
  • call4
ansgar posted 5 months ago

Oh I guess you found a bug :)

Please report that in the issue tracker.

Please login to leave a reply, or register at first.