no more PREPARE and EXECUTE statement in stored procedure

[Stéphane De Blois]

i know in Mysql 5.0.9 no more PREPARE and EXECUTE statement is allowed. How you'r gone execute a stored procedure with an input parameter which it's used to build a dynamic SQL query .


CREATE PROCEDURE `bd`.`test`( IN pcustomerid int())
BEGIN
declare where_condition varchar(1000);

if(pcustomerid >0)
set where_condition = concat(' where customerid = ', pcustomerid);
else
set where_condition = '';

set @str_sql = concat('Select * From my_view', where_condition )

PREPARE stm_str_sql FROM @str_sql;
EXECUTE stm_str_sql;

in MySQL 5.0.9 i got this message : PREPARE is not allowed in stored procedurer