Zeoslib Portal

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

que

using triggers is not best solution:
1) loss of flexibility, complicated process flow understanding and unhandy debugging
2) unsuitable for my problem - loading data, not storing

que

functions via select, procedures via call like i wrote above: call spMySuperSP(param); :) I'm writing megasecure app with all its logic on server side, so my app will communicate with db hrough sp calls not via select/insert/update an so on. That's why i'm asking about full sp support, not only one ...

que

example

Code: Select all

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`spMySuperSP`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `spMySuperSP`()
    READS SQL DATA
BEGIN
  select * from b;
END$$

DELIMITER ;

que

zippo Procedures do not return values if I'm not wrong - functions do that. Functions returns only scalar data types, but procedures returns data through OUT or INOUT parameters or returns datasets like SELECT operator, but i can not use 'call spMySuperSP(param);' in TZQuery, cause mysqlerror "...

que

ZStoredProc is not implemented for mysql

(((((
My stored procedure returns dataset... Is there any other way i can use it?
Or when sp support will be implemented?

Search found 6 matches