Subject BLOB UDF Problem ...
Author Intertex
Hello,

I have a problem writing simple UDF for FB.
I'm use Firebird-1.5.0.4290_embed_win32 and Delphi 7 for UDF.
I have large table "Q" (over 50 000 records) that contain BLOB field.
I want write small UDF that would read this BLOB field and make some
changes.

So, I try to use simple sample from
borland: http://bdn.borland.com/article/0,1410,25785,00.html

I have register my function exactly as in sample:

declare external function fn_BlobCat
Blob,
Blob,
Blob
Returns parameter 3
entry_point 'BlobCat'
module_name 'BlobConcat.dll';

Problem:
When I try to load all records from my program
SELECT
fn_BlobCat(...)
FROM
Q;

It's "eat" all my memory and work only on computers where 1GB of
memory installed - if computer have less than 1GB - "Out of
memory/system resources..." error appear. However, without UDF
function I can read all records from this table.

It's seems memory (BLOBs) not released after using any UDF function???

Thanks