I have a simple stored proc as following.
DELIMITER $$CREATE DEFINER=`dbadmin`@`%` PROCEDURE `Test_TruncateTable`(IN `spTableName` TEXT) MODIFIES SQL DATA COMMENT 'Truncates staging table.'BEGIN
TRUNCATE TABLE spTableName;
END$$DELIMITER ;
The procedure won't get executed, it throw's following error.
#1.
#2.
I tried changing the IN parameter to VARCHAR etc. but no luck. In past I have wrote more complicated procedures having multiple parameters however never run into the above mentioned error.
Discussion posts and replies are publicly visible