AllExperts > MySQL 
Search      
MySQL
Volunteer
Answers to thousands of questions
 Home · More MySQL Questions · Answer Library  · Encyclopedia ·
More MySQL Answers
Question Library

Ask a question about MySQL
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About stuart gregory
Expertise
PHP html, xhtm, css coding and MySQL

Experience
My experiance is all first had as i am web developer and i have and do build many websites all using php and mysql. This ranges from building a search engine to secure php login scripts. some websites like http://www.mylifelink.co.uk are complete database driven websites.

Organizations
I have a large number of websites which i host and maintain, such as. http://www.webreger.com http://www.mylifelink.co.uk http://www.lush-lingerie.com http://www.scotchpiper.co.uk http://www.mysafesearch.co.uk http://www.lush-lingerie.com

Education/Credentials
Web application development. (Open University) BSC Honers Computing and development (Open University)

 
   

You are here:  Experts > Computing/Technology > Databases > MySQL > Calling Procedure

MySQL - Calling Procedure


Expert: stuart gregory - 10/7/2009

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

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.