CREATE OR REPLACE procedure test26 is -- Clipping --------------- l_blob blob; l_text varchar2(255) := 'Hello World! Hello World! Hello World!'; l_length number; begin l_length := plpdf.GetTextWidth(l_text); plpdf.init; -- initialize, without parameters means: page orientation: portrait, unit: mm, default page format: A4 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.StartClipping(20,15,40,50); for l_i in 1..6 loop plpdf.PrintCell(l_length,10,l_text,'1',1); -- print text: cell size:50*10 end loop; plpdf.EndClipping; 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; /