creating pdf documents using pl/sql create pdf in pl/sql generate pdf in pl/sql
pdf by pl/sql pl/sql Oracle Sql PDF pl/sql pdf generate
tool develop oracle pl/sql download
creating html_db applications
spacer
plsql generate pdf
html_db spacer Home Examples
printemail html_db printed report

26. Clipping

CREATE OR REPLACE procedure test26 is
-- Clipping
   ---------------
  l_blob blob;
  l_filename varchar2(30) := '123.pdf';
  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-Disposition: inline; filename="' || l_filename || '"'); 
        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;
/

 

Source: test26.prc

Result: test26.pdf

spacer
pl/sql pdf
mod_plsql pdf