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
6262
November 26, 2008 05:29PM
3447
November 28, 2008 05:07AM
3321
November 28, 2008 05:35AM
3474
November 28, 2008 07:28PM
Re: il cursore non interpreta la sintassi
3532
November 30, 2008 09:52AM
3423
December 11, 2008 06:31AM
3394
January 15, 2009 04:16AM
3402
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.