|
From: Robert M. <rob...@gm...> - 2007-06-21 15:08:27
|
On 6/21/07, Maury Hammel <ml1...@sh...> 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 |
