APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX4.0 Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your website or blog.

You are here:
Follow us on Twitter
Region Plugin Embedded PDF

Embedded PDF

9
Categories: Region Plugin
Author: Anton Scheffer

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.

Version 0.806

  • removed refence to utl_file
  • added optional header text

version 0.805

  • handle colum names with a space
  • better handling of a line which doesn't fit on the page

Version 0.800

  • Initial version

Keywords
region, PDF, PL/SQL

Example
Example
Company: AMIS
Date added: 5.11.2010
Views: 14836
Votes: 12
Reviews: 43
Min. APEX Version:
4.0
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:




Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
0 
@Novaterra
by Anton Scheffer
on March 27, 2014
Create a new region in your application, based on this plugin. Change any settings if you want and enter a source query.
0 
RE: How to plug-in to generate PDF
by Novaterra
on March 27, 2014
Hi,
I want to use the plug-in to generate pdf. I have download and install the plug-in. I don't know how to use it. Could you please give me information how configure the plug-in?

Thank you in advance.

Arthur
0 
IE 11
by Dann
on March 12, 2014
Does not display data using IE 11. Works fine with Chrome.
0 
can not display
by suvashish
on February 28, 2014
Dear,
i use this plug in and use it preview link also showing but pdf have no data. can anyone help me plz
10 
I got it to work now.
by Scott
on November 15, 2013
This is what I needed:
t_widths as_pdf3.tp_col_widths;
t_headers as_pdf3.tp_headers;

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.
10 
@Scott
by Anton Scheffer
on November 14, 2013
Strange, but this works for me:

declare
t_query varchar2(1000);
t_widths as_pdf3.tp_col_widths;
t_headers as_pdf3.tp_headers;
begin
as_pdf3.init;
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.save_pdf;
end;
0 
Sample as_pdf3.query2table with
by Scott
on November 14, 2013
I am trying to use as_pdf3 as a standalone package. It is very a nice package, but I am trying to get the headers and column widths correct in the query2table procedure. All the samples I see only show the first parameter used. I would like a working sample using all three. I can not get the headers and column widths to work. No matter what I try I get an PLS-00306 wrong number or type of arguments in call to query2table.

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.
0 
Generate PDF from PL SQL Block
by sanjeevi
on August 21, 2013
Hi

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.

Regards
Sanjeevi
0 
@Ramani
by Anton Scheffer
on February 4, 2013
I have know idea what you have done or want, but I think this plugin doesn't do what you want. It takes a query, and show the char, number and date columns in a PDF table. And it's not to show stored blobs.
0 
Read PDF file from table
by Ramani
on February 4, 2013
i have added embedded region and download this, and i select FILE_BLOB from my_blob_table where id=1...

its showing error!!!

how can read blob(file) from table?please reply me..
Thanx ,
Ram
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.