Expert: stuart gregory - 10/7/2009

Question
QUESTION: Hi,

I have 80 procedures and I want to call all the procedure one by one
Automatically and I am passing a value run time. All procedures have the same parameter.

I create a procedure and call the procedure in this procedure but it is not working .

For example

REATE PROCEDURE dataaccp.`PRC_DATA_ACCEPTANCE`(IN P_client_name VARCHAR(20))
BEGIN
     CALL prc_get_error_1 (p_client_name);
     CALL prc_get_error_2 (p_client_name);
     CALL prc_get_error_3 (p_client_name);
     CALL prc_get_error_4 (p_client_name);
..
..
..
End;

        
        


ANSWER: Dear Sir

How are you trying to run this script. If this is a script that a browser can call the information from a database then you would use a while loop or for loop for example in php.

for more information on php and MySQL try using the website and there forum at

http://www.web-application-development.info

---------- FOLLOW-UP ----------

QUESTION: I am using Toad for mysql for run .
i am not using php . just creating a procedure in which i am calling 80 procedures in this procedure it is runing only few but not all but when i am trying to run one by one it is working propely.

Need your help  

Answer
Dear Sir,

I am not use to using Toad, i tend to stay away from all programs like that for refrence to MySql, i either use a php script in the admin area of the website or i use phpmyadmin on the server as thats were the database is original created plus its more sucure and up to date