27.06.2019 18:09, Adriano dos Santos Fernandes wrote:
Here a small example of how it could be used for writing data in chunks
Isn't one function to create a blob in temporary space enough instead of all
this?
For example:
execute block returns (b blob)
as
begin
b = DBMS_LOB.CreateTemporary();
b = b || '12345';
b = b || '67';
suspend;
end!
Parser can be clever enough to append string to the end in such cases without copy of
whole blob content.
Of course, DBMS_LOB.Append can exists as well as a syntax sugar.
--
WBR, SD.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel