Re: il cursore non interpreta la sintassi
la tua stored function non funziona perchè:
ERROR 1336 (0A000): Dynamic SQL is not allowed in stored function or trigger
io però sinceramente ho creato una stored così:
DROP PROCEDURE IF EXISTS `db`.`executeQuery`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `executeQuery`(queryT VARCHAR(255))
BEGIN
set @sql_text:=queryT;
PREPARE stmt1 FROM @sql_text;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
END$$
che mi esegue il codice che gli mando come parametro di ingresso..
però non funziona con i trigger..
Subject
Views
Written By
Posted
6311
November 26, 2008 05:29PM
3481
November 28, 2008 05:07AM
3340
November 28, 2008 05:35AM
3503
November 28, 2008 07:28PM
Re: il cursore non interpreta la sintassi
3553
November 30, 2008 09:52AM
3442
December 11, 2008 06:31AM
3419
January 15, 2009 04:16AM
3425
December 01, 2008 09:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.