Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Problem with call procedure

pdusp's profile image pdusp posted 8 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's profile image Misha v.3 posted 8 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);
SELECT @;
pdusp's profile image pdusp posted 8 months ago

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

1 attachment(s):
  • call4
ansgar's profile image ansgar posted 8 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.