current community

your communities

more stack exchange communities

Stack Exchange
tour help
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.
up vote 0 down vote favorite

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

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

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.