procedures and cursors
hi all,
i have this procedure:
delimiter $$
drop procedure if exists select_imp$$
create procedure select_imp()
BEGIN
declare output text default '';--string to print
declare matricola int(10) unsigned;
declare Nome char(20);
declare Cognome char(20);
declare Dipart char(15);
declare Ufficio char(3);
declare Stipendio decimal(9,2);
declare done int default 0;
declare imp cursor for select * from Impiegati;
declare continue handler for SQLSTATE '02000' set done=1;
open imp;
fetch imp into matricola,Nome,Cognome,Dipart,Ufficio,Stipendio;
while done do
set output=concat(matricola,',',nome,',',cognome,',',Dipart,',',Ufficio,',',Stipendio,'\n');
fetch imp into matricola,Nome,Cognome,Dipart,Ufficio,Stipendio;
select output;--should print the string output
end while;
close imp;
END$$
delimiter ;
when i call it i have no output.Could you please help me?Thank you.