Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am creating a procedure in a new database. There is no trigger on any table and no procedures exist. I am getting this error:

ERROR 1303 (2F003): Can't create a PROCEDURE from within another stored routine

What does this mean? How do I solve it?

share|improve this question
It would be helpful if you'd post the actual command throwing this error – druzin Jun 3 '13 at 12:07
up vote 1 down vote accepted

Just what it means. Some commands cannot be invoked from within stored routines. Creation of a stored routine is one of them. As another example, you cannot LOAD DATA INFILE from a stored routine.

You may try and do it with a prepared-statement, only to find that CREATE PROCEDURE cannot be invoked via prepared statement.

Sorry - no way around this that I know, and I've done my share of search on this.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.