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

1. Minimal example

CREATE OR REPLACE procedure test1 is
-- Minimal example
---------------
-- Default values:
-- Encoding: cp1252
-- Header: null
-- Footer: null
-- Margins: left: 1cm, right: 1cm, top: 1cm, bottom: 2cm
-- Interior cell margin: 1mm
-- Line width: 0.2mm
-- AutoNewPage: true
-- DocDisplayMode: fullwidth
-- Compress: true
-- DocTitle: null
-- DocObject: null
-- DocAuthor: null
-- DocKeywords: null
-- DocCreator: null
-- nopAlias: null

l_blob blob;
l_filename varchar2(30) := '123.pdf';
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.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-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: test1.prc

Result: test1.pdf

spacer
pl/sql pdf
mod_plsql pdf