	AllExperts > MySQL
	Search

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