create or replace procedure JPGStamp_test is l_blob_30 blob; l_blob_50 blob; l_blob_107 blob; begin select t.blob_file into l_blob_30 from store_blob_tk t where t.filename = '00_ReadMe.pdf'; select t.blob_file into l_blob_50 from store_blob_tk t where t.filename = 'image1.jpg'; dbms_lob.createtemporary(l_blob_107,TRUE); l_blob_107 := plpdf_toolkit.JPGStamp( p_inputfile => l_blob_30, p_imagefile => l_blob_50, p_x => -1, p_y => -1, p_width => 200, p_height => 200 ); delete from store_blob_tk where id = 107; insert into store_blob_tk (id,blob_file,filename,desctext) values (107,l_blob_107,'JPGStamp.pdf','id:30 + id:50 JPGStamp'); commit; end; /