CREATE OR REPLACE procedure test33 is
-- AttachFile
   ---------------
 
  l_blob blob;
  l_pdf blob;
 begin
   select blob_file
	    into l_pdf
	  from store_BLOB
	  where rownum < 2;
    
    plpdf.init; -- initialize, without parameters means: page orientation: portrait, unit: mm, default page format: A4
    plpdf.AttachFile('test.pdf',l_pdf);
    plpdf.NewPage; -- begin a new page, without parameters means: page orientation: default (portrait)
    plpdf.SetPrintFont('Arial',null,12); -- set font attributes: family: Arial, style: regular, font size: 12
	   plpdf.PrintCell(50,10,'Hello World!'); -- print text: cell size:50*10
    plpdf.SendDoc(l_blob); -- create content
	
	-- print
	/*
	owa_util.mime_header('application/pdf',false);
        htp.p('Content-Length: ' || dbms_lob.getlength(l_blob)); 
        owa_util.http_header_close; 	
        wpg_docload.download_file(l_blob);
        */
    
	-- or store
	insert into STORE_BLOB (blob_file, created_date) values (l_blob, sysdate);
	commit;
 end;
/