create or replace procedure Encrypt40_test is l_blob_10 blob; l_blob_101 blob; begin select t.blob_file into l_blob_10 from store_blob_tk t where t.filename = 'plpdf-toolkit-install-v100.pdf'; dbms_lob.createtemporary(l_blob_101,TRUE); l_blob_101 := plpdf_toolkit.encrypt40( p_inputfile => l_blob_10, p_opassword => 'apple', p_upassword => null, p_canextractcontent => false, p_canmodify => true, p_canmodifyannotations => true, p_canprint => false ); delete from store_blob_tk where id = 101; insert into store_blob_tk (id,blob_file,filename,desctext) values (101,l_blob_101,'Encrypt40.pdf','id:10 plpdf-toolkit-install-v100.pdf Encrypt40'); commit; end; /