Subject | Procedure problems when upgrading from 1.0.3 to 1.5.1 |
---|---|
Author | marijoaou |
Post date | 2004-09-07T13:05:49Z |
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
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