Subject | Re: out-of-memory failure with BLOB |
---|---|
Author | |
Post date | 2019-01-09T14:04:39Z |
Thank you for your answer
If I replace blob by varchar, no issue (script at the end of this post)
So, I don't understand why it couldn't work also with blob, it's not logical. Why blob are not released in this case, why keep blob id ?
Thank you
SET TERM ^ ;
CREATE OR ALTER PROCEDURE BLOB_MEMORY_TEST2
RETURNS (
B VARCHAR(1000))
AS
declare variable i integer;
begin
i = 0;
while (i < 15E6) do
begin
select b from BLOB_MEMORY2 into b;
i = i+ 1;
suspend;
end
end^
CREATE OR ALTER PROCEDURE BLOB_MEMORY2
RETURNS (
B VARCHAR(1000))
AS
begin
/* Procedure Text */
b = 'Test';
suspend;
end^
SET TERM ; ^
SELECT * FROM BLOB_MEMORY_TEST2;