create or replace procedure ExtractText_test is l_blob_10 blob; l_blob_104 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_104,TRUE); l_blob_104 := plpdf_toolkit.ExtractText( p_password => null, p_encoding => 'UTF-8', p_startPage => 1, p_endPage => 1, p_inputfile => l_blob_10 ); delete from store_blob_tk where id = 104; insert into store_blob_tk (id,blob_file,filename,desctext) values (104,l_blob_104,'ExtractText.txt','id:10 plpdf-toolkit-install-v100.pdf ExtractText'); commit; end; /