Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
4  
It would be helpful if you'd post the actual command throwing this error –  druzin Jun 3 '13 at 12:07
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.