MySQL Bugs: #13342: Dynamic Statement in Stored Procedures

Bug #13342	Dynamic Statement in Stored Procedures
Submitted:	20 Sep 2005 9:15	Modified:	20 Sep 2005 13:58
Reporter:	Rahul Chaudhari	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S2 (Serious)
Version:	MySQL 5.0.12	OS:	Linux (Linux box)
Assigned to:	Assigned Account	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Hi All,

    In mysql normal stroed procedures are grtting created easily, but then why dynamic queries are not used in store procedures in mysql.

  whenever i'm using prepare stmt. mysql say that perpare is removed from stored procedures.

  dynamic queries are more important in stored procedure.

   Please look into seriously.

Regards
Rahul Chaudhari

How to repeat:
NO

Suggested fix:
NO

This isn't a MySQL Administrator issue. The same issue is related to bug:

http://bugs.mysql.com/bug.php?id=12614

also see: http://dev.mysql.com/doc/mysql/en/routine-restrictions.html

Thank you for the bug report.