Subject Re: [firebird-support] Procedure problems when upgrading from 1.0.3 to 1.5.1
Author Helen Borrie
At 01:05 PM 7/09/2004 +0000, you wrote:
>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 ^;
>'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.

>...procedure code
>END ^