create or replace procedure PDFWatermark_test is l_blob_60 blob; l_blob_70 blob; l_blob_114 blob; begin select t.blob_file into l_blob_60 from store_blob_tk t where t.filename = 'plpdf_package-v170.pdf'; select t.blob_file into l_blob_70 from store_blob_tk t where t.filename = '1-5.pdf'; dbms_lob.createtemporary(l_blob_114,TRUE); l_blob_114 := plpdf_toolkit.PDFWatermark( p_inputfile => l_blob_60, p_overlayinputfile => l_blob_70 ); delete from store_blob_tk where id = 114; insert into store_blob_tk (id,blob_file,filename,desctext) values (114,l_blob_114,'PDFWatermark.pdf','id:60 + id:70 PDFWatermark'); commit; end; /