You are here:

MySQL/Calling Procedure

Advertisement


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

MySQL

All Answers


Answers by Expert:


Ask Experts

Volunteer


stuart gregory

Expertise

PHP html, xhtml, 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 simple search engine to secure php login scripts. Some websites like http://www.web-application-development.info 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.protorrent.co.uk http://www.web-application-development.info http://www.mythslegendsandfolklore.co.uk

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

©2012 About.com, a part of The New York Times Company. All rights reserved.