[Firebird-devel] Cached BLR in FB 2.1 (released version)?

[Poul D. <pd...@ta...>]

I have a strange behaviour in my code.

I have a stored procedure that calls other SP's and does som calcutlation and summing from a table. If I compile the procedure and run it everything is fine. If I then disconnect and connect again to the database, the return value is wrong (its a procedure that in this case should return 4 that returns 0).

Each time I compile the procedure, the result will be correct and seemingly remain correct until I reconnect - and then it will be wrong.

The procedure is recursive via doing sums on a calculated field that in turn calls this procedure as well.

I had default values in the input parameters for the procedure but I deleted the default values to see if this did the trick; However, the problem remains. I have variables with default values in the procedure and I didn't try to change these (yet).

Before I go any further with this problem: Does the above problems ring a bell? Maybe something that has even been corrected in FB 2.1.1? My next step is of course to install 2.1.1 but I can't do that right now :(

Regards
Poul Dige