CREATE OR REPLACE procedure test18 is -- Multiline cell l_blob blob; 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 -- plpdf_util.print_blob(l_blob); -- or store insert into STORE_BLOB (blob_file, created_date) values (l_blob, sysdate); commit; end; /