User Cannot Execute DDL Scripts for Stored Procedures Created within Toad for MySQL 


Problem 

DDL scripts, for Stored Procedures, created within Toad for MySQL v2.0.1 cannot be executed by external programs such as MySQL Query Browser or MySQL Command-Line Tool. As a result, the files created by Toad for MySQL cannot be use for deployment. 
 

Cause 

If the DELIMITER command is not specified or used, the script will not run in other tools. This is due to the limitation of the parser of the server. 

Toad will allow the user to execute the script for procedures regardless of the DELIMITER command. 

 

Resolution 

WORKAROUND

In order for the scripts to be executed by programs outside of Toad for MySQL, the DELIMITER command is required. 

Prior to using the DELIMITER command in Toad for MySQL v2.0.1, the QP5.DLL file will need to be replaced as follows:

1) Exit out of Toad for MySQL 2.0
2) Go to your Toad for MySQL 2.0 directory.
3) Locate the QP5.DLL file and rename this to QP5.DLL.OLD.
4) Download teh QP5.zip file to obtain teh QP5.DLL (v5.35): 
5) Extract this file and copy into the Toad for MySQL 2.0 directory.
6) Open Toad for MySQL and execute the script.

An example of the DELIMITER command being used is as follows:

DELIMITER // 
CREATE PROCEDURE GuyTest (p1 int) 
BEGIN 
Select * from movies.customer; 
END; 
// 
DELIMITER; 

Here is the script that was generated for the above procedure from Query Browser: 

DELIMITER $$ 
DROP PROCEDURE IF EXISTS `movies`.`GuyTest`$$ 
CREATE PROCEDURE `movies`.`GuyTest`(p1 int) 
BEGIN 
Select * from movies.customer; 
END $$ 
DELIMITER; 

To execute the above, use the F5 command to "Execute SQL Script."