Creating temporary table in procedure in mysql i face an error

See more:

MySQL

CREATE PROCEDURE pTest()
    BEGIN
        CREATE TEMPORARY TABLE tblTest (
            OrderDate varchar(200)
        );
        DROP TEMPORARY TABLE tblTest;
    END//

SQL query:

CREATE PROCEDURE pTest( ) BEGIN CREATE TEMPORARY TABLE tblTest(
OrderDate varchar( 200 )
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5