18. Print flowing text

CREATE OR REPLACE procedure test18 is
-- Print flowing text
l_blob blob;
l_filename varchar2(30) := '123.pdf';
l_link number;
begin
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.PrintFlowingText(5,
'Generate dynamic PDF documents from data stored in Oracle databases ' ||
'using the PL/PDF program package. PL/PDF is written exclusively in PL/SQL. ' ||
'It is able to either store the generated PDF document in the database or ' ||
'provide the results directly to a browser using MOD_PLSQL. No third-party ' ||
'software is needed; PL/PDF only uses tools provided by the installation ' ||
'package of an Oracle Database. Use PL/PDF to quickly and easily develop ' ||
'applications with dynamic content but also quality ' ||
'presentation and printing capabilities.');
-- print flowing text: text heigth: 5

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: test18.prc

Result: test18.pdf