Problem with call procedure

[expired user #11851]'s profile image [expired user #11851] posted 5 years ago in General Permalink

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
[expired user #1502]'s profile image [expired user #1502] posted 5 years ago Permalink

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 @;
[expired user #11851]'s profile image [expired user #11851] posted 5 years ago Permalink

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

1 attachment(s):
  • call4
ansgar's profile image ansgar posted 5 years ago Permalink

Oh I guess you found a bug :)

Please report that in the issue tracker.

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