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

Reply via email to