Problem with call procedure

pdusp posted 1 week 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 1 week 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);
SELECT @;
pdusp posted 1 week ago

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

1 attachment(s):
  • call4
ansgar posted 1 week 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.