At 05:02 AM 30/11/2007, you wrote:

>I am hit a memory leaking problem with Firebird UDF under Windows XP.
>
>Here is what I did:
>
>1. First create a stored procedure 'UDF_TEST' with just one UDF
>function 'F_STRINGLENGTH'.
>
>SET TERM ^ ;
>CREATE PROCEDURE UDF_TEST
>AS
>DECLARE VARIABLE STR_1 VARCHAR(20);
>DECLARE VARIABLE POS_1 INTEGER;
>DECLARE VARIABLE IDX INTEGER;
>BEGIN
>
> STR_1 = '10-A-10';
>
> IDX = 0;
> WHILE (IDX <= 20000) DO
> BEGIN
>
> /* UDF function */
> POS_1 = F_STRINGLENGTH(STR_1);
>
> IDX = IDX + 1;
>
> END
>
>END^
>SET TERM ; ^
>
>2. Open the Windows Task Manager.
>3. Execute the stored procedure, and watch the memory usage.
>4. Run the stored procedure several times, the Firebird will raise the
>following exception and the leaking memory has been released.
>
>*** IBPP::SQLException ***
>Context: Statement::Execute( EXECUTE PROCEDURE MEM_TEST )
>Message: isc_dsql_execute2 failed
>
>SQL Message : -902
>Unsuccessful execution caused by a system error that precludes
>successful execution of subsequent statements
>
>Engine Code : 335544721
>Engine Message :
>Unable to complete network request to host "localhost".
>Error reading data from the connection.
>
>If I put the UDF function statement in the comment, and execute the
>stored procedure. There would be no memory leaking problem.
>
>Then I execute the following UDF function statement 1000 times:
>
>SELECT F_STRINGLENGTH('10-A-10') FROM RDB$DATABASE;
>
>The memory usage is clearly growing up.
>
>Then I disconnect the database, those used memory was not released.
>
>This problem can reproduced on 2 desktops. I think both of the
>desktops have the same environment:
>
>Operation System: Windows XP Pro
>Firebird: Firebird 2.0.1 (Win32 Build)
>UDF: 2007-02-09
>
>Anyone has any idea if I did something wrong. Or there is the way to
>work around the problem. Your help is appreciated.

You are not releasing memory after your calls to the string function. Tell us

1. where you obtained this UDF (if you wrote it yourself, show the code)

2. what your declaration of the UDF looks like.

./heLen