Subject Procedure problems when upgrading from 1.0.3 to 1.5.1
Author marijoaou
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' ^

CREATE PROCEDURE DOSOMETHING(a INTEGER,b INTEGER,

...procedure code

END ^
SET TERM ;^

Thank you very much for reading and if you are able to help even
better :)

MariJo