MySQL Storedprocedures

[que]

Hehe.... i just found the solution for my problem:

Just added connection property
CLIENT_MULTI_STATEMENTS=true

After this calls to stored procs work in TZQuery

[Rogier21]

With the new release of ZEOS, can I just use the TZStoredProc component?

I use it like this and it looks really handy.

Code: Select all

  StoredProc1.Active:=False;
  StoredProc1.StoredProcName:='test_proc';
  StoredProc1.ParamByName('@param_id').AsInteger:=1;
  StoredProc1.ExecProc;
  StoredProc1.Active:=True;

But i get the same error as the topic starter; parameter not found (yet i tried more then this possibility )