Embedded PDF Tweet
A native PDF-generator
This is a plugin, which can be used to get the output of a query as PDF, which is embedded in your application. No print-server, such as FOP, BI Publisher or Cocoon is necessary.
region, PDF, PL/SQL
Do you have a question about this Plugin? Want to write a Review or Comment?
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
I had declared my own arrays and tried to use them, even though they match the types that as_pdf3 was using, that was never going to work.
t_query := 'select rownum, sysdate + level, ''example'' || level from dual connect by level <= 50';
t_widths := as_pdf3.tp_col_widths( 100, 75, 300 );
t_headers := as_pdf3.tp_headers( 'COL 1', 'COL 2', 'COL 3' );
as_pdf3.query2table( t_query, t_widths, t_headers );
as_pdf3.query2table(ls_query) -> works
as_pdf3.query2table(ls_query, NULL, NULL) - > works
if I substitute anything for the nulls, even arrays, I get an error.
In my application there were 3 PL Sql block region in which html template is designed using PL Sql block and table is designed based on the output. I need to generate an pdf where i will be show the 3 region in the same pdf. Need your help in optimizing the plugin. I have tired PL_FPDF but i need to upgrade my DB server to install Oracle InterMedia which is not possible.
its showing error!!!
how can read blob(file) from table?please reply me..
Ive a report based on htp.p() stataments to create the kind of below report ie, i tried using the plugins but is giving some errors please give me a suggestion on how to use the plug-in with report layout like this,
Customer ID: x3001 First Name: John
city: Austin State: Texas Zip: 07854
Oops, something went wrong.
ORA-06539: target of OPEN must be a query
ORA-06512: at line 999
Can you please give a guidance how to use PDF-generator plug-in? I just downloaded a plug-in and imported on my application but i don't know what do next in order for me generate pdf file.
Thank you in advance for your help.
|Powered by Sigsiu.NET|