MySQL Forums :: Stored Procedures :: prepared statement within stored procedure mysql

Hi All,

I have created prepared statement within stored procedure. But when I execute procedure I got a error message says as "#1243 - Unknown prepared statement handler (auto_partition) given to EXECUTE"

Please let me know what is wrong with below procedure.

CREATE PROCEDURE auto_partition()
BEGIN
DECLARE _stmt VARCHAR(1024);
SET @l_SQL := CONCAT('ALTER TABLE tbl_location_history ADD PARTITION (PARTITION ', concat( 'Part_Y', year( now( ) ) , '_M', month( now( ) ) , '_W', week( now( ))+1), ' VALUES LESS THAN (TO_DAYS(\'', DATE_FORMAT(date_add(NOW(), interval 15 day),'%Y-%m-%d'), '\')));');
PREPARE _stmt FROM @l_SQL;
EXECUTE _stmt;
DEALLOCATE PREPARE _stmt;
END

Thanks in advance.

Thanks,
Deva