TZReadOnlyQuery shows error with valid query

[poetzschpadborg]

Hi,
I am new to this forum, but I have been using ZeosLib Components with Delphi and Lazarus for the past 10 years or so. I'm mostly using it to access MySQL Databases.

Now I have run into a strange Problem with TZReadOnlyQuery.

In my MariaDB database I have a pretty complex stored procedure that takes some input parameters, one inout param and one out param. Because of the error I get, when I try to call it with TZReadOnlyQuery, I have made a very simple procedure to test it.
This is my test procedure:


I tried to call this procedure from different MySQL query/managment tools with this statement:

Code: Select all

select @x = 'inputparam';
call MyProc(@x, @y);
select @x, @y;

I get the expected answer: a dataset with one record and two fields like this:


But when I add the same query statement to a TZReadOnlyQuery and try to open it I get an error message:

errormessage.jpg

Does anyone around here have any idea why this happens and how to work around it?

TIA
Lutz Kutscher

BTW: I tried to add my procedure definition and call as text, but then my post was blocked:

[marsupilami]

Hello Lutz,

I am pretty sure, Zeos 7.2 doesn't support inout params. Could you test what happens on Zeos 8.0? Zeos 8.0 is currently only available from the SVN or from Github.

About the blocked message: This forum is run on Servers from SourceForge and we use MySQL as the forums database. I assume, they try to protect themselves and us from SQL injection by some software. This is something we cannot change in any way.

With best regards,

Jan