Re: Retrieving results from a select in a procedure

[Eric Walker]

I finally found the way out of it :

DELIMITER $$

DROP PROCEDURE IF EXISTS `waldataservers`.`StockQuots`$$
CREATE PROCEDURE waldataservers.StockQuots (aWalident integer)
BEGIN
DECLARE a integer;
DECLARE GzStr char(40);
select GeoZone into a from Dbstocks where (WalIdent=aWalident);
select Name into GzStr from DbstocksCat where (Ident=a);
set GzStr =Concat('select * from qticks_',GzStr,' where (DateIdx>=200510121600000000)');
set @a = GzStr;
PREPARE test from @a;
execute Test;
deallocate prepare test;
END$$

DELIMITER ;

comments :

For the prepare statement I had to use a "global variable" @a, I couldn't get it to work with a "local" variable :
"Prepare Test from GzStr"; will allways return a syntax error ?