Solved

MySQL Stored Procedures Limitation

Posted on 2012-03-13
2
290 Views
Last Modified: 2012-03-13
Hello All,

I am moving from MSSQL over to MySQL and I have a simple question, is there a limit to the number of stored procedures you can have in a database?  Basically, I've success in creating the sps, however they do not exist on the list or when I call them.  I seem to only be able to store 3 procedures. The 3 that are there run fine but I have the written 9 so far.  I have search all over with no luck, any assistance would be greatly appreciated.

Thanks,
Darrell
0
Comment
Question by:darrellajames
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 37717034
there is no limit of number of stored procedures, for sure not 3 or 9.
you might check if you did not create them in another database that your user database...
0
 

Author Closing Comment

by:darrellajames
ID: 37717185
Thanks so much.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question