Re: PL/SQL Broken in 2.5.1

Try this:

begin
      update sometable set something = somevalue where somecriteria;
end;
/

Rob

On 9/14/07, Alain Wong <alainwong@xxxxxxxxx> wrote:
>
>  Hi all,
>
>  Wondering if you can run a very simple PL/SQL in 2.5.1?
>  e.g.
>  begin
>      update sometable set something = somevalue where somecriteria;
>  end;/
>
>  The error is:
>  PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
> following:
>
>     ;
>  , SQL State: 65000, Error Code: 6550
>
>
>  I think it is a problem of statement separator and procedure separator of
> the Oracle Plugin.
>  It just failed no matter how I set the config in Oracle Plugin or session
> properties.
>
>  The same works in 2.4 but not 2.5.1. I have not tested it in 2.5 as 2.5's
> decimal flaw is a show stopper to me.
>  Of course in 2.4, I have to change the statement separator to "/" in
> session properties in order to run PL/SQL.
>
>  Please help!
>
>  Thanks,
>
>  Alain
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/