|
From: Robert M. <rob...@gm...> - 2007-07-10 10:41:36
|
On 7/2/07, Robert Manning <rob...@gm...> wrote: > On 6/29/07, Dan Climan <dc...@my...> wrote: > > > > > > > > > > Is there a way to creat a stored procedure in MySQL using Squirrel-SQL? > > > > > > > > I have a valid stored procedure that I can create in the db using a mysql > > <filename.sql > > > > > > > > Every attempt to run this query through squirrel results in syntax errors. > > > > I've tried a DELIMTER // command and changing the session delimiter, but > > that didn't work. > > > Support needs to be added in the MySQL plugin for parsing stored > procedures and other constructs. We'll see if we can get that in soon > - we have an outstanding request for it here: > > http://sourceforge.net/tracker/index.php?func=detail&aid=1466324&group_id=28383&atid=393417 > > It would be helpful if you would provide some sample script for > creating stored procedures that would be similar to ones that you > would expect SQuirreL to handle. If you decide to provide any sample > script(s) you can attach them to the feature request above. Support for handling stored procedure create statements has been added to the MySQL plugin. Please try out the snapshot build available at the link below, and let us know how it goes (The default "end-of-procedure" character is "|" but can be changed in the MySQL tab of the Global Preferences dialog. If there is a better default to be using, let us know that too) http://sourceforge.net/project/showfiles.php?group_id=28383&package_id=158128&release_id=522159 Rob |
