MySQL Forums
Forum List  »  Stored Procedures

Re: Creating a stored routine from within a stored procedure
Posted by: Davide Cicuta
Date: February 24, 2013 08:02AM

Thank you very much for your reply.

Ok, I get it that SQL has definitely not been designed to do that, but I achieved the results I need in both SQL Server and Oracle. Ok, different produts, different features, but apparently also in MySQL there is the chance of executing runtime-defined DDL statements and over the net there are examples of people creating that way at least tables. I realize creating tables is (syntactically) different than creating routines, but that made me figure that the problem was just in the syntax. After all, creating a table is more demanding than creating a routine.

Is there really no way of creating a routine from a stored procedure?

Thanks in advance for your replies!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Creating a stored routine from within a stored procedure
1054
February 24, 2013 08:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.