--- In firebird-support@yahoogroups.com, "B" <branislavns@...> wrote:

>
> Hi,
>
> I have a database with around 7MB in file size.
> Inside there is a few procedures and one is giving me a headache.
>
> Inside of an procedure is a output variable type blob, where a few for-select-do loops are putting some data.
> There is no insert, update or delete in that procedure, just a few for-select-do loops.
> All data are filled in one output variable (type blob) witch usually return around 20KB of data inside of an blob.
>
> What is the problem ?
>
> When I call this procedure database enlarge itself for around 80MB per call, again, again and again..... I tried to call this procedure a few times and database became an 1,4GB, even more.
>
> If I use s sweep , nothing happens.
>
> When I backup it and restore it returns to original size of 7MB.
>
> Any clue ?
>
> P.S. I tried with Firebird 2.5.1.26351 64bit on WIndows 7 and latest daily build but results are the same.
>

Solution is to replace blob type with varchar - it is some kind of firebird bug.