dkeith2 wrote:

> Is there a setting in firebird.conf that would allow me to allocate more memory to the instance so that this query could run?

No. This error means that the operating system simply doesn't have any
available memory (or you get out of the process address space).

> I've tried many permutations of this, but all eventually run out of resources.

Don't use blobs instead of varchars unless strictly required. Your
procedure creates a lot of temporary blobs (intermediate operation
results). Every such blob occupies around <page size> bytes of memory
for the whole transaction lifetime.

FB 2.5 works better in this regard, but this practice is still not
friendly to the engine.


Dmitry