MySQL Forums
Forum List  »  Stored Procedures

Re: how to execute a parameter which contains an sql instruction in the body of a stored procedure
Posted by: Roland Bouman
Date: August 11, 2005 01:59AM

Jod75 wrote:
> Is dynamic SQL going to be supported by MySQL?

It is supported, check out:

http://dev.mysql.com/doc/mysql/en/sqlps.html

It's just not supported in Stored procedures (anymore, it used to be supported before 5.0.7 but dont pin me on the version please. It was withdrawn due to various issues).

> so, is there a date when this is going to be

I don't know that

> implemented? Stored procedures without dynamic
> sql have very limited use.

I'd say it would be a very powerful feature, but I think it's way too far to say 'very limited use'.

Check out this these threads:

http://forums.mysql.com/read.php?98,35310

http://forums.mysql.com/read.php?98,22770

http://forums.mysql.com/read.php?98,34930

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to execute a parameter which contains an sql instruction in the body of a stored procedure
1891
August 11, 2005 01:59AM


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.