create or replace procedure Decrypt_test is l_blob_20 blob; l_blob_103 blob; begin select t.blob_file into l_blob_20 from store_blob_tk t where t.filename = 'plpdf-toolkit-install-v100_sec.pdf'; dbms_lob.createtemporary(l_blob_103,TRUE); l_blob_103 := plpdf_toolkit.decrypt( p_inputfile => l_blob_20, p_password => 'pass12345' ); delete from store_blob_tk where id = 103; insert into store_blob_tk (id,blob_file,filename,desctext) values (103,l_blob_103,'Decrypt.pdf','id:20 plpdf-toolkit-install-v100_sec.pdf Decrypt'); commit; end; /