Oracle PL/SQL library BLOB_WRAPPER: Reading content of a file into a blob

This is an example on how BLOB_WRAPPER can be used to read the content of a file into a table.
The file that is read into the table was created with this script
create table tq84_blob_wrapper_test (
  id  number primary key,
  blb blob
);
declare
  blob_ blob;
begin
  insert into tq84_blob_wrapper_test values (1, empty_blob() ) return blb into blob_;

  blob_wrapper.from_file('LOB_TEST_DIR', 'circle_new.txt', blob_);
end;
/
The source code for this exaple is on github.
Go back to library's main page