Mysql stored procedure using TZStoredProc

[matejka]

Hi,
i'm using Zeos DBO 6.6.0, MySQL 5.0.41 and I need to retrieve result set from stored procedure. I've used TZStoredProc with params like this:

StoredProc1:=TZStoredProc.Create(nil);
StoredProc1.Connection:=Connection1;
StoredProc1.Params.CreateParam(ftInteger, 'param1', ftInput);
... other params added
StoredProc1.Open; // exception here

But exception of "Unsupported operation" occurs when calling Open (same error when calling Exec). I use only IN params in this procedure.

Is there anything wrong in my code?

thanks

Jiri Matejka

[mdaems]

No... Nothing's wrong with your code. TZStoredProc is not supported for mysql, however. You should just use a TZQuery component (or TZReadOnlyQuery) ans use 'Call proc(param)' as the SQL statement.

There are plenty of examples on the forum already.

Mark

[matejka]

Thanks for help, I'll try it.

Jiri Matejka