Oracle PL/SQL library BLOB_WRAPPER: Writing a blob from a table into a file

This is an example on how BLOB_WRAPPER can be used to write the content of a blob in a table into a file.
The blob in the table was created with this script.
declare
  blob_ blob;
begin

  select blb into blob_ from tq84_blob_wrapper_test;
  blob_wrapper.to_file('LOB_TEST_DIR', 'circle_from_table.txt', blob_);

end;
/
The source code for this exaple is on github.
Go back to library's main page