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

[20 Sep 2005 9:15] Rahul Chaudhari 
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
[20 Sep 2005 13:58] MySQL Verification Team 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.037 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.