Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does anyone uses PL_FPDF?

milkMar 21 2011 — edited Jun 4 2012
I need help.
I want to print a simple spreadsheet of employees.
The problem is if the text is longer than the cell,
passes over the following cell and doesn't go in a new row of the same cell.

This is an example.

Thanks!

begin
pl_fpdf.FPDF('P','mm','A4');
pl_fpdf.openpdf;
pl_fpdf.setdisplaymode ('fullpage', 'single');
pl_fpdf.AddPage();
pl_fpdf.SetFont('Arial','',9);

pl_fpdf.cell(15,7,'ID','B');
pl_fpdf.cell(60,7,'Name','B');
pl_fpdf.cell(30,7,'Lastnmae','B',1);
for c in (select id,name,lastname from emp order by lastname) loop
pl_fpdf.Cell(15,5,c.id);
pl_fpdf.Cell(30,5,c.name);
pl_fpdf.Cell(30,5,c.lastname,null, 1);
end loop;
pl_fpdf.Output(Emp.pdf','I');
end;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2012
Added on Mar 21 2011
27 comments
5,018 views