## PROCEDURE  CREATE

DROP PROCEDURE IF EXISTS ACCT.MYSQL_MULTI_TEST;

CREATE PROCEDURE ACCT.`MYSQL_MULTI_TEST`(

    $SQL             VARCHAR(8000) 

)

BEGIN

   DECLARE count INT DEFAULT 0;

   SET @SQL = $SQL;

   SET @COUNT = 1;

  PREPARE STMT_CONTENT FROM @SQL;

  EXECUTE STMT_CONTENT;    

  DEALLOCATE PREPARE STMT_CONTENT;	

END;

##  PROCEDURE  CALL ( error) 

CALL  MYSQL_MULTI_TEST(' 

  DELETE FROM MYSQL_MULTI_DELETE_1;  

  DELETE FROM MYSQL_MULTI_DELETE_2;

  DELETE FROM MYSQL_MULTI_DELETE_3; 

 '); 

 ## PROCEDURE  CALL ( ok )

 CALL  MYSQL_MULTI_TEST('

    IF( 1 = 1 )  THEN 

        DELETE FROM MYSQL_MULTI_DELETE_1;

        DELETE FROM MYSQL_MULTI_DELETE_2;

        DELETE FROM MYSQL_MULTI_DELETE_3;

    END IF;      

 ');