create or replace procedure Merge_test
  is
  l_blob_10 blob;
  l_blob_30 blob;
  l_blob_105 blob;
begin
   select t.blob_file
    into l_blob_10
  from store_blob_tk t
  where t.filename = 'plpdf-toolkit-install-v100.pdf';
  
  select t.blob_file
    into l_blob_30
  from store_blob_tk t
  where t.filename = '00_ReadMe.pdf';
  
  dbms_lob.createtemporary(l_blob_105,TRUE);
  
  l_blob_105 := plpdf_toolkit.Merge(
    p_inputfile1 => l_blob_10,
    p_inputfile2 => l_blob_30
    );
    
  delete from store_blob_tk where id = 105;
  insert into store_blob_tk 
    (id,blob_file,filename,desctext) 
    values 
    (105,l_blob_105,'Merge.pdf','id:10 + id:30 Merge');
  commit;  
end;  
/