Re: MySql Stored Procedures and Squirrel

On 4/6/06, Chris Roberts <fishlet <at> yahoo.com> wrote:
> Hi All,
>
> Now I just have the default installation... it's got some kind of MySQL plugin... but perhaps it's grossly
out of date. Has anyone had any experience working with MySQL stored procedures without having to leave Squirrel?

The MySQL plugin was developed several years before MySQL allowed stored
procedures, so no, I'm pretty sure that it doesn't support showing the
text of an
stored procedure.  The plugin just needs to be updated to supported showing
 the text in a "source" tab when the procedure is clicked on in the
object tree -
much like what is already done in the Oracle plugin.  You can submit a feature
request for this here:

http://sourceforge.net/tracker/?group_id=28383&atid=393417

As far as running stored procedures, make sure that you use a "safe"
statement separator in "Session Properties" in the "SQL"
tab.  By default it's semi-colon (;) which is often seen one or more times in
the body of most stored procedures I've seen (Oracle PL/SQL.  I've haven't
worked with MySQL's stored procedures yet).  You could - for example - use
"FOO" as the separator and just highlight your procedure create statement
and run it.

Rob Manning

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642