Re: Trouble executing storedprocs in SQuirreL

On 6/21/07, Maury Hammel <ml1.hammel@xxxxxxx> wrote:
> The problem here is that SQuirreL, by default, uses the semi-colon as a
> terminator.  So it is breaking up the begin/end block into two
> statements, which Oracle chokes on.  In order to get SQuirreL to send
> the entire begin/end block as a single statement, you need to go to the
> SQL tab in the Session Properties dialog, and change the "Statement
> Separator" to something other than an semi-colon.  What I usually did
> was change it to the / (slash) character.  Then you can run the
> procedure with the following:

This is no longer necessary when using the Oracle Plugin.  It uses a
custom QueryTokenizer that handles stored procedures and anonymous
blocks using Oracle's "/" terminator.  See my previous email.

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/