Re: creating a mysql stored procedure

On 7/2/07, Robert Manning <robert.m.manning@xxxxxxxxx> wrote:
> On 6/29/07, Dan Climan <dcliman@xxxxxxxxxx> 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

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/