create or replace procedure ReplaceUrl_test
  is
  l_blob_40 blob;
  l_blob_106 blob;
begin
  select t.blob_file
    into l_blob_40
  from store_blob_tk t
  where t.filename = 'link.pdf';

  dbms_lob.createtemporary(l_blob_106,TRUE);
  
  l_blob_106 := plpdf_toolkit.ReplaceUrl(
    p_inputfile => l_blob_40,
    p_oldURI => 'http://www.yahoo.com/',
    p_newURI => 'http://www.plpdf.com/'
    );

  delete from store_blob_tk where id = 106;
  insert into store_blob_tk 
    (id,blob_file,filename,desctext) 
    values 
    (106,l_blob_106,'ReplaceUrl.pdf','id:40 ReplaceUrl');
  commit;  
end;  
/