At 01:05 PM 7/09/2004 +0000, you wrote:

>Hi,
>
>Has anyone run to following kind of a problem when trying to upgrade
>functional stored procedures from firebird 1.0.3 to 1.5 ?
>
>Dynamic SQL Error
>-SQL error code = -104
>-Unexpected end of command
>Statement failed, SQLCODE = -104
>invalid request BLR at offset 534
>
>This error occures in two procedures that both start with exception
>definition so I figured the problem might have something to do with
>that or what could be the problem. (Most of my procedures are going
>fine to the new Firebird).
>
>Has anyone got any idea why these 1.0.3 procedures do not compile to
>the 1.5.1 server ?
>
>The procedure scripts are essentially structured as below.
>
>set TERM ^;
>
>CREATE EXCEPTION MY_EXCEPTION
>'My exception' ^

Assuming you are using the exception in the procedure, you will need to
commit the exception definition before you try to compile the SP. Nothing
changed in this regard.

>CREATE PROCEDURE DOSOMETHING(a INTEGER,b INTEGER,
>
>...procedure code
>
>END ^
>SET TERM ;^

./helen