Help on PL_FPDF PDF Generator
Hi,
Could any one guide me how to Generate a PDF from oracle DB, I have downloaded the PL_FPDF specification and body in my local schema and tried executing the hello world program
create or replace procedure helloworld is
begin PL_FPDF.FPDF('P','cm','A4');
PL_FPDF.openpdf;
PL_FPDF.AddPage();
PL_FPDF.SetFont('Arial','B',16);
PL_FPDF.Cell(0,1.2,'Hello World',0,1,'C');
PL_FPDF.Output();
end helloworld;
*/*
exec helloworld;
but i ended up getting the error
Error report:
ORA-20100: <B>PL_FPDF error: </B>Output : ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SBALAGAN.PL_FPDF", line 1939
ORA-06512: at "SBALAGAN.PL_FPDF", line 3487
ORA-06512: at "SBALAGAN.HELLOWORLD", line 7
ORA-06512: at line 1
Additional Info:_
1. I am trying this from SQLPLUSW.... Can we execute these things from sqlplusw, if no, then how do we execute it?
2.While i compiled the PL_FPDF it asked for value as given below( pls see the value i gave)
SQL> @y:\pdf.pkb
Enter value for gt: 1000
Enter value for lt: 900
old1933: print(replace(replace(pdfDoc(i),'>','>'),'<','<'));
new1933: print(replace(replace(pdfDoc(i),'>','1000;'),'<','900;'));
Enter value for lt: 900
Enter value for gt: 1000
old3480: htp.prn(replace(replace(replace(pdfDoc(i),'<', '<'),'>','>'),chr(10),'<br/>'));
new3480: htp.prn(replace(replace(replace(pdfDoc(i),'<', '900;'),'>','1000;'),chr(10),'<br/>'));
Package body created.
Guide me in moving forward to generate a PDF at the earliest since i am doing this as Proof Of Concept for a project..