Links » Support » Oracle Forums about PL/PDF

Re: PLPDF 2010/01/06
I also granted execute on plpdf to apex_public_user. However, it also didn’t work. I have Oracle 11g.

http://<host>.<port>/pls/<dad>/test2

CREATE OR REPLACE procedure test2 is

l_blob BLOB;

begin

  -- this program calls printer receipt through a browser

  Plpdf.init;

  Plpdf.Newpage;

  Plpdf.SetPrintFont('Arial',null,12);

  Plpdf.PrintCell(50,10,'Test2');

  Plpdf.SendDoc(l_blob);

  -- print

  owa_util.mime_header('application/pdf',FALSE);

  htp.p('Content-Length: ' || dbms_lob.getlength(l_blob));

  owa_util.http_header_close;

  wpg_docload.download_file(l_blob);

end test2;

/

Re: PLPDF 2010/01/06
This page provides the example I think you are looking for:

http://plpdf.com/23-953.html

Basically it outputs the PDF contents directly to the browser after setting content type, length, etc.

You should even be able to put this as a pre-header, page process or an on-demand process in APEX.

-Richard
Re: PLPDF 2010/01/06
My problem was that, when I called the URL: http://hostname:port/pls/<dad>/test, the page couldn’t be displayed – test is the name of the stored procedure. The PL/PDF packages were installed under the plpdf schema. I already granted execute on the main plpdf package to the schema that needed to run reports. Do you know what the problem was? Also, how can I construct the URL if I want to change the stored procedure into a program with some parameters inside a database package. Therefore, the call should be something like <package name>.<program name>(parameter1, parameter2).

There are not too many PL/PDF examples in OTN’s apex forums.

Thanks.
Andy
PLPDF Attaching Files 2009/08/26
Is it possible to attach or concatenate any number of PDF files to the PDF document that I generate using PLPDF ?

The files that need to be attached are in the file system, not in the database.

I looked at plpdf.attachfiles procedure but could not clearly tell if it can be used. Do I need to install the PLPDF toolkit whichs is a Java library with PL/SQL interface ?

TIA.
Re: PLPDF experience / references 2006/07/21
Hi Richard,

You will find all the info on www.plpdf.com .

Here is an example :
create or replace PROCEDURE test2 IS
l_blob BLOB;
BEGIN
Plpdf.init;
Plpdf.NewPage;
Plpdf.SetPrintFont(’Arial’,NULL,12);
Plpdf.PrintCell(50,10,’Test2′);
Plpdf.SendDoc(l_blob);
– print
owa_util.mime_header(’application/pdf’,FALSE);
htp.p(’Content-Length: ‘ || dbms_lob.getlength(l_blob));
owa_util.http_header_close;
wpg_docload.download_file(l_blob);
END;

Francis.
Convert font by using plpdf? 2010/03/30
Hi there.

Is it possible to convert font in oracle reports 6i and store this pdf into database by using plpdf?

Thank you.

Regards.
Re: PLPDF experience / references 2006/10/12
hello,,

i would like to use the plpdf, it looks for me very interistion,, but does it work on unix servers??

Sam.
PLPDF error (on shellprompt.net) 2006/12/11
Hi,

I’m trying to produce a simple PDF via my Apex application (hosted on Shellprompt.net) using the following after-header process

DECLARE
l_blob BLOB;
BEGIN
Plpdf.init;
Plpdf.NewPage;
Plpdf.SetPrintFont(’Arial’,NULL,12);
Plpdf.PrintCell(50,10,’Test2′);
Plpdf.SendDoc(l_blob);
– print
owa_util.mime_header(’application/pdf’,FALSE);
htp.p(’Content-Length: ‘ || dbms_lob.getlength(l_blob));
owa_util.http_header_close;
wpg_docload.download_file(l_blob);
END;

But I get a ‘ORA-20000: Certification key is invalid. Please contact Support.’ error.

Any idea why?
Anyone using PLPDF 2005/06/21
Looking for other HTMLDB developers using PLPDF. I am hoping to find someone willing to share their experience and possibly tips/tricks on implementing. I have not gotten it working yet but I am also seeking help directly from PLPDF.

In a brand new application, I have added a page (1) with a page item (p_par1) and a button on it which branches to page 2. The page 1 HTML header contains the javascript from this page at plpdf.com: http://plpdf.com/23-1250.html. I’ve created a database procedure (rep1) which basically contains the print option of the Hello World example from pldf.com (http://plpdf.com/23-953.html) but instead of ‘Hello World’, I am passing in the contents of p_par1 as the text. I am not using the PLPDF_SESSION_IS_VALID function at this time.

Thanks in advance for any suggestions,
Noelle
Re: PLPDF experience / references 2005/12/11
Thanks Arie,

Most of the post about PLPDF are from llokodi who works for PLPDF…

That is why I am looking for other references

Are you using it ?
Is it easy to use ?
What about licensing ?

I am looking for references from people using the tool.

Before posting I did some googling and forum searches but did not get much.

Francis.
Re: PLPDF experience / references 2005/12/11
Hi Francis,

Search this forum for PLPDF, and you’ll get several references to the product, some of them from active users.

Regards,
Arie.
Using PLPDF on XE Production 2006/03/20
Hi,

I’m using Oracle XE Production and would like to add pdf output in my APEX application using PLPDF. I followed the installation guide but can’t get it working. Even testing the installation fails.

The install guide says:

“the document can be reached through a browser
url: http://<host>:<port>/pls/<DAD>/test2″

Using the example from www.plpdf.com for integrating plpdf in HTMLDB and typing in http://127.0.0.1:8080/rep1 (I left out the parameters) to test leads to an error page 400. Does anyone know how to integrate it successfully in XE production?

Already tried two install versions: First creating a plpdf user following the install guide and second installing plpdf under the workspace user account. None was successful.

Thanks
PLPDF experience / references 2005/12/11
Hi everyone,

Anyone with PLPDF experience (good or bad) ?

We are planning on maybe using this product and we are looking for references concerning usability, support and pricing.

Thanks

Francis.
Re: PLPDF experience / references 2005/12/12
Arie,

it should be possible to run it on XE.

They have reworked the related packages.

You can download the version in their download section: http://www.plpdf.com/23-927.html

I haven’t used pl/pdf myself.

~dietmar.
Re: PLPDF experience / references 2006/06/27
Hi,

i’ve a question. I’m planning to use plpdf for reporting with htmldb.
I’ve successfully installed it on a WIN NT SERVER + oracle Xe.
My needs are:

store pdf in a blob (i think i’ve done it using example test1 of plpdf).
Now i’ve this pdf inside a table STORE_BLOB where i’ve added as well an id field.

How can i dowload them using a report with link on id_field?
an example please.
Note that i’ve a user named plpdf and i’ve created an htmldb application in this workspace.
Maybe my problem is only how to download the file contained in a blob field.

p.s.

I’ve already fixed. PLPDF WORKS GREAT. Forgot to grant access to PUBLIC / MY HTMLDB USERS.

thanx

Message was edited by:
user512322
Re: Using PLPDF on XE Production 2006/07/13
Hopser2000,

Do you get your PDF in an different window with this solution?

I want to generate a PDF with PLPDF.

Richard
PLPDF ibm z/os 2007/06/06
Hi guys
Does someone use plpdf package on database instaled on IBM z/os?
I’ve try it, it works Ok on 10g instaled on Linux platform but not work on BM z/os.
It generate blob but can’t open it.
Thanks
Re: PLPDF experience / references 2006/10/12
Sam,

PL/PDF is a third-party product, you get the software from -

http://www.plpdf.com/

It installs into the database (hence it works on both windows and unix), there is also pretty comprehensive documentation on the PL/PDF website on how to install and use it.
Re: PLPDF experience / references 2006/10/12
Does anyone know how PLPDF stacks up against the common (& free) Apache FOP method of creating PDFs from Apex / PLSQL? Is it possible to create complex reporting layouts via both of these libraries?

Has anyone tried both?
Re: PLPDF experience / references 2006/11/23
Mike,

its very easy to place individual fields, you can specify the exact x/y coordinates where the field should start and how big it should be.

Have a look at the examples page: http://www.plpdf.com/23-4766.html

Greetings,
Dirk
Re: PLPDF experience / references 2005/12/11
Hi,

I started to look into the product myself, following some good comments I read on this forum, but I didn’t install the product yet, because I’ve been told he’ll not run on the new XE version.

My main resource so far is their web site www.plpdf.com. You can see there some specific references to HTML DB, including some source code examples (then you’ll be able to decide for your self if it’s easy to use, or not). BTW I entered the site today, following your message, and it seems like it can be run with XE so I’ll resume my interest in the product.

As for licensing and pricing, you can also get this information on the site. Last I checked it was $300 per server.

Regards,
Arie.
Re: Using PLPDF on XE Production 2006/03/20
How can I find out which DAD is used? I’m new to the topic of using DAD.

From within SQLPlus I already granted execute priviliges to the plpdf user’s procedures. In which way and how can I configure a new DAD?
how to user oracle intermedia and plpdf to display image 2006/08/14
Hi all,

AS i know plpdf is very retriction to display images and i think it only valid for jpep and may be gif file extension. Can i display any kind of different file of format if i’ve both oracle intermedia and plpdf in my database. If yes, can you give me an exampe how to work that this.

Thank you very much,

Kevin
pdf mail merge like / FOP / PLPDF 2006/06/27
Hi to all,

does exist any products that run as well with Oracle xe, that allow user to do a ‘mailmerge like’ linking with data?

I’ll try to explain better what i’m looking for:

1- A Model designer will do the pdf, with graphic and map the db field according to the existing tables field (or other substitution logic).
2- The application developer will link the data to the pdf Model.

I’ve tried plpdf today and works great, however what i’ve explained at point 1, 2 doesn’t seem to be possible with PLPDF.

Another question: if you have tested both FOP / PLPDF what kind of solution would you suggest for a fast pdf generation / data merging?

thanx
Best Practices for creating PDFs using PLPDF? 2006/03/02
Does anyone have any suggestions for Best Practices in making PDF files using PLPDF?

I have been using it for about a month now, and the best that I have come up with is to use MS Access to prototype the layout of a report. Once I have all the graphics areas and text areas lined up how I would want them, I then write PLSQL code to create a procedure which is called from an HTMLDB page. MS Access is handy in that it provides the XY coordinates for each text area and graphics area. It also provides the dimensions of the respective cells. So long as I call plpdf.Init(’P', ‘in’, ‘letter’) at the beginning of the procedure, both my MS Access prototype and my plpdf code are both using inches – this makes the translation relatively easy.

Has anybody found anything else easier/better?

Regards,
PLPDF 2010/01/06
I purchased the PL/PDF software but couldn’t find out how to “directly” call the .pdf document from the web server without saving it in a table. I tried the provided example but it didn’t work.

Thanks.
Andy
Verifying APEX session validity from PLPDF 2006/11/07
On PLPDF tips page (http://plpdf.com/23-1250.html) there is an advice to verify session’s validity before going further with report rendering.

To verify the session’s validity, the following select is used:
SELECT id INTO l_id
FROM FLOWS_020000.WWV_FLOW_SESSIONS$
WHERE id = p_session_id;

Assuming that I do not want to modify and recompile my reporting packages each time I upgrade APEX (FLOWS_020000=> FLOWS_020200 => FLOWS_020210, etc…), is there a possibility to get this session information using a view(s) that are not changing names from one version to another?

I have tried APEX_WORKSPACE_SESSIONS from sqlplus after having connected to my test application, but no rows were returned. Am I missing something?
Project Similar to PLPDF – Permissions to external Jar for reading-writing 2008/10/30
hi all,I explain my situation.I ‘ ve made an open source project similar to plpdf using jasper report libraries and others.My project, which works perfectly in a java jre, have some problems in Oracle Aurora jvm.I use the Reflection technique to load the classes from their libraries.For this i use this class :java.lang.reflect.InvocationTargetExceptionat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)at java.lang.reflect.Method.invoke(Method.java)at org.Reflection.Utility.executeMethod(Utility.java)at org.EngineReport.ReportControl.compileJrxml(ReportControl.java:44)at org.EngineReport.ReportOracle.getReportByte(ReportOracle.java:130)at org.EngineReport.ReportOracle.ReportAsBlob(ReportOracle.java:69)at org.EngineReport.ReportOracle.ReportAsBlob(ReportOracle.java:49)Caused by: java.security.AccessControlException: t …
Re: PLPDF 2010/01/06
It would be that if you had either a public synonym or a synonym under APEX_PUBLIC_USER for that, otherwise it is schema.package.procedure.

Either way, APEX_PUBLIC_USER also requires execute rights on the package.

Also, if this is a more recent version of APEX, there is an additional security procedure that must be updated in order to allow execution of non-Apex code through the Apex DAD. See the link below for more info.

Restricting Access to Oracle Application Express by Database Access Descriptor (DAD):

http://download.oracle.com/docs/cd/E14373_01/admin.32/e13371/adm_wrkspc.htm#AEADM209

-Richard
Re: PLPDF 2010/01/07
Ok. You have the grant, but what owner is the TEST2 procedure under and do you have a public synonym for it?

Also, did you look at the link and add that procedure into the APEX delivered code mentioned in it? It is a security restriction in order to keep anything that may be publically executable from being run through the DAD without you explicitly allowing it.

-Richard
Re: PLPDF 2010/01/11
Have you added it to the function:

APEX_030200.wwv_flow_epg_include_mod_local (or the same under whatever your current version of APEX is)

As described in : http://download.oracle.com/docs/cd/E14373_01/admin.32/e13371/adm_wrkspc.htm#AEADM209

-Richard
Re: PLPDF 2010/01/12
You using Embedded Gateway or modplsql to access APEX?

Enable the debug display. For modplsql the DAD parameter is

PlsqlErrorStyle DebugStyle

For Embedded Gateway:

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_epg.htm#BABFFDEH

Use DBMS_EPG.SET_DAD_ATTRIBUTE for attribute ‘error-style’ and value ‘DebugStyle’

Then go to the page again and lets see what error you get.

-Richard
Re: Anyone using PLPDF 2005/11/30
I would love some help on this topic as well. I’m about where you are, so sorry I can’t be of any help. Anyone else using this?
Re: Anyone using PLPDF 2005/11/30
Hi Noelle,

I’m using PL/PDF and I think it’s a fantastic product.

What do you mean by ‘I have not gotten it working yet’, what specific problem are you having? Do you not get any output? Do you get an error message? Do you get the wrong output?
Re: Anyone using PLPDF 2005/11/30
Jes, I’m also having problems getting this to work, if you have a moment to help me. Right off the top, the second bullet point in the documentation states “…should contain a button that when pressed, the values of the parameter fields are passed to the report and the report is opened in another window”. I’m not sure how to do this. Can you shed some light on this? Also, it states in the third bullet point: “The HTML DB page in the background in the meantime jumps to another HTML DB page”. What page is this? I’ve done the “detailed steps”, but I don’t get an error message or anything. My report pops right up like a normal HTMLDB report. I’m assuming that having a second window is very important to make this all work. Do you (or anyone else) have a simple report you’ve done with PL/PDF that I might be able to look at? I’m so lost it’s not even funny… Thanks! Steve …
Re: PLPDF experience / references 2005/12/12
I use PL/PDF and have had nothing but good experiences with it, the support from PL/PDF has also been exceptional.
Re: PLPDF experience / references 2005/12/12
fyi I heard that the PDF functionality should be added to the version 3.0 of HTML db. I don’t know if this is true but my personal opinion is that this functionality will “boost” it up quite a bit.

Denes Kubicek
Re: PLPDF experience / references 2006/07/11
Marcello,

Does this work? How do you get the pdf in a browser? I only can dowload it with tools like TOAD.

Richard
Re: PLPDF experience / references 2006/07/13
Hi Marcello,

“Maybe my problem is only how to download the file contained in a blob field.”

This is also my problem. Can you tell me how it works?

Richard
Re: PLPDF experience / references 2006/10/12
jos,

how you make it? do u have the installer?

Sam.
Re: PLPDF experience / references 2006/10/12
but does it work on unix servers??

yes.
Re: PLPDF experience / references 2006/11/22
Jes,
We require to generate a couple of quite heavily formatted Reports (Header and Footer section with fixed width boxes, and central section containing 5 detail lines). I’m aware of possible options such as Oracle Reports, XML Publisher and FOP, but would PL/PDF be an option here? How flexible is the Report layout using this option?

Thanks,

Mike
Re: PLPDF experience / references 2006/11/22
Hi Mike,

You can certainly define headers and footers in PL/PDF, so yes it could definitely be an option for you.
Re: PLPDF experience / references 2006/11/22
Jes,
Thanks for the response. How easy is it to define where individual fields are placed on the page, or do you have to stick to a fairly tabular layout?

Thanks,

Mike
Re: Convert font by using plpdf? 2010/03/30
Can we convert report to blob file and convert blob’s font by using pl/pdf program?

Regards.
Re: Convert font by using plpdf? 2010/03/31
PL/PDF is software to create pdf files programmatically with pl/sql. I don’t see the relation with Oracle Reports. Do you want to convert a report that was written in Reports to a report written with pl/pdf? You will have to do that manually.
Re: PLPDF error (on shellprompt.net) 2006/12/11
Andrew,

You should really report that sort of problem via the Shellprompt support (since you’re mentioning it specifically).
Re: PLPDF error (on shellprompt.net) 2006/12/11
I know, sorry, but I don’t have access to internet email at the moment. Can you help though?
Re: PLPDF error (on shellprompt.net) 2006/12/11
Hi Andrew,

Yes I can but since it’s a Shellprompt support issue we will need to discuss it privately (i.e. not in this forum).

Drop me an email to the usual address when you do have access to your internet email.
Re: Using PLPDF on XE Production 2006/03/20
hopser2000,
```
 http://127.0.0.1:8080/rep1
```
Which DAD is that URL using?
Re: Using PLPDF on XE Production 2006/03/20
Does not work. I tried a lot of changes to the url but without success.

When calling my developed app the link look as follows: http://127.0.0.1:8080/apex/f?p=100….

What’s the DAD? APEX?

Do you know how to configure the DAD in Oracle XE?
Re: Using PLPDF on XE Production 2006/03/20
Hopser2000,

I wasn’t suggesting you use that URL, I was asking which DAD the URL you used was using. From the Installation docs that you quoted -
```
"the document can be reached through a browser

url: http://<host>:<port>/pls/<DAD>/test2"
```
The procedure needs to be access via a DAD. You can either use the existing DAD (and therefore you will need to grant access to that procedure to the user specified in the DAD), or you will need to setup another DAD which has the appropriate rights to access your procedure.
Re: Using PLPDF on XE Production 2006/03/20
Your problem seems to be related to the tightened security in XE production.

Check this thread for resolution:
http://forums.oracle.com/forums/thread.jspa?messageID=1240740#1240740

~Dietmar.
Re: Using PLPDF on XE Production 2006/03/20
You need to grant
```
grant execute on xxx to ANONYMOUS;
```
since the DAD APEX (default in XE production) is executed via the database account ANONYMOUS.

~Dietmar.
Re: Using PLPDF on XE Production 2006/03/20
Does not work

Granted execute to my workspace user and modified the function wwv_flow_epg_include_mod_local setting the OWNER.FUNCTION_NAME in the list of the “allowed” procedures/functions.

Calling the url http://127.0.0.1:8080/apex/my_owner.my_function leads to error page 403 – access forbidden.
Re: Using PLPDF on XE Production 2006/03/20
```
Granted execute to my workspace user
```
You’re not granting access to the workspace user, you need to grant access to the user that is being used to access the database via the DAD.

Have a look at Dietmar’s post, he shows you what you need to do.
Re: Using PLPDF on XE Production 2006/03/20
…sorry, did not add the function name in uppercase! Now it works!! Thanks.
Re: Using PLPDF on XE Production 2006/03/20
Excellent, glad you’ve got it working
Re: Using PLPDF on XE Production 2006/03/20
Thank you for helping so quickly.
Re: Generate PDF files from PL/SQL Procedure 2005/01/09
check this: www.plpdf.com
Re: Write data from a table into pdf file 2009/07/31
http://www.plpdf.com/
Re: Verifying APEX session validity from PLPDF 2006/11/07
Igor – If the call can be issued from within an Application Express HTTP request context, you can call htmldb_custom_auth.is_session_valid (boolean function).

Scott
Re: Verifying APEX session validity from PLPDF 2006/11/07
Scott,

Your advice is only working for authenticated pages? For “public” pages, this function is not a solution, right?

Just to make things clear…

THX!
Re: Verifying APEX session validity from PLPDF 2006/11/07
This is easy to test.

I will test it.

Maybe you will first.

Scott
Re: Verifying APEX session validity from PLPDF 2006/11/07
Damir,

The function returns true if you’ve authenticated using an authentication scheme that uses built-in session management and its associated cookie mechanisms, whether or not the page requires authentication. It returns false in all other cases.

Scott
Re: Verifying APEX session validity from PLPDF 2006/11/07
Scott,

If I understand you right, all I have to do is to condition the visibility of the print triggering item (for example, print button) by htmldb_custom_auth.is_session_valid – and no more package-level checks necessary?
Re: Verifying APEX session validity from PLPDF 2006/11/07
Igor – I don’t know the correct answer. You can try it and see how it works.

Scott
Re: Verifying APEX session validity from PLPDF 2006/11/07
Scott,

You have correctly cit ate my thoughts….if user is not authenticated then function is worthless…otherwise OK!

THX

P.S.
For such a pages we have built other “verification” method. Igor, Scott…interested to explain?
Re: Verifying APEX session validity from PLPDF 2006/11/07
Damir,

As I see it, if one needs to protect a function from unauthorized access, it means that the user must be authenticated. Otherwise, no check would be necessary.

However, if it does not bother you to explain your verification method, you are welcome.
Re: Verifying APEX session validity from PLPDF 2006/11/08
OK…this post will be short and if there will be more interested I can explain widely. Idea is based on “session” like random definition but in much shorter usage then session id…. 1) Create app item G_SEC_CODE, which will have “Before header” computation like: fnc_random_text(6); — generate random pattern of 6 signs! In this way this number will be all the time different on ANY page (authenticated and public) 2.On popup page/function that you call you should have parameter P_SEC_CODE, where you will put G_SEC_CODE of the page that has call it: procedure my_proc(p_sec_code IN VARCHAR2; …) IS BEGIN if p_sec_code!=v(’G_SEC_CODE’) THEN — wrong or unallowed call! return; end if; … END; If you want to protect popup page then this is easy mechanism. In popup page (suppose page_id is “2″) you should have one hidden item P2_SEC_CODE and in “On load-before header” process place next plsql code: IF NVL(:G_SEC_CODE,’x') != NVL(:P2_SEC_CODE,’y') THEN …
Re: writing in pdf format 2006/03/08
use plpdf ,i was using the same , it is very good tool.

www.plpdf.com
Re: "utl_smtp" "attach a file" 2006/03/01
see http://plpdf.com/23-1725.html
Re: APEX and pdf 2006/12/18
More specifically, you might want to search for ‘PLPDF’.

Earl
Re: APEX Reports PDF or DOC 2006/05/01
Can’t Oracle just buy www.plpdf.com?
Re: pdf document 2007/11/11
Yes you can: http://plpdf.com/

Dim
Re: Sending BLOB as mail attachment 2006/01/31
see http://plpdf.com/23-1725.html
Re: convert stored .pdf into clob using CTX_DOC.IFILTER 2010/03/24
If you need are looking at alternatives you might try PL/PDF -http://plpdf.com/#/products/plpdf-toolkit. It’s reasonably priced.
Re: Output to pdf. 2005/06/07
Perhaps the possibilities offered by PLPDF is more suited for your type of enhanced reporting.

Take a look at http://www.plpdf.com/
Re: Using PL/PDF with Oracle XE 2005/12/20
new version of plpdf (v1.2.3) supports XE. you can download from www.plpdf.com.
Re: PL/PDF – Procedure test1 is executed but gives error 2010/04/21
PL/PDF uses “execute immediate” for calling header and footer procedure as plpdf owner. If header/footer procedure owner is different plpdf main procedure owner then you have to “grant” (and “synonym”) to plpdf owner.
Re: attaching file using utl_smp 2005/06/16
see: http://www.plpdf.com/23-1725.html
Re: Creating PDF file using PL/SQL 2006/01/03
Hi,

perhaps this may help you: http://www.plpdf.com/

Dim
Re: export as csv ,xls ,pdf etc.. 2005/01/09
Generate PDF from PL/SQL: www.plpdf.com
Re: Generate pdf reports inside stored procedure 2006/10/27
see www.plpdf.com for generating PDF inside database…
Re: How create query based .txt, .pdf file in SQL/PLSQL 2009/06/24
There is a commercial tool called plpdf, but i can’t tell if its good.
Re: How to create pdf file using oracle pl/sql 2008/12/24
Check out [pl/pdf|http://www.plpdf.com]
Re: How to create report with page breaks? 2005/03/10
I use pl/pdf to generate pdf document(www.plpdf.com)…
Re: How to email BLOB as file attachment 2005/09/29
see http://www.plpdf.com/23-1725.html
Re: PDF Generators for Application Express 2007/01/10
Hi Bob,

I can recommend PL/PDF (www.plpdf.com)
Re: PDF reporting? 2005/11/23
Programmatically, you may like to check out pl/pdf – www.plpdf.com
Re: pl/pdf changing size of page 2008/12/15
use plpdf.Init1 and you can set custom page size….
Re: pl/pdf page number 2010/01/15
Hi,

You could try the function plpdf.CurrentPagenumber.

Regards

Michael
Re: PDF Printing 2008/08/21
? I’ve tried that link several times just now and it always took me to the plpdf.com home page.

Try just www.plpdf.com

Andy
Re: PDF Generators for Application Express 2007/01/11
Hello,

If you installed PL/PDF into it’s own schema then you’ll need to -

1) Grant permissions to that package to the user you are using

2) Either fully qualify the package names (e.g. if you installed into schema ‘plpdf’, then you would use ‘plpdf.plpdf.init’, i.e. ’schema.packagename.method’).
or
3) Create a global synonym for the PL/PDF packages so that you can just type plpdf.init and it references the plpdf.plpdf package.

Hope this helps.
Re: PL/PDF – Procedure test1 is executed but no PDF file generated 2010/02/26
Hi Bhushan,

Have you tried PLPDF for support?
[http://plpdf.com/support|http://plpdf.com/support]
I have always found them to be helpful.

Running plpdf.senddoc(l_blob) will output the pdf document inline to the browser (a bit like htp.p() ).

by the way:
You can’t mix and match plpdf.senddoc(l_blob) and htp.p(), you will create a Frankenstein’s Monster of a page!

Try some of the examples that they provide and you should get a better feel for how it works.

Regards

Michael
Re: Using PL/PDF with Oracle XE 2005/12/02
pl/pdf uses java:
- compressing page (plpdf_comp package): we issue a modified package for XE (without compress) see http://plpdf.com/dokumentumok/plpdf_comp_xe.sql.txt with some restrictions
- image (Oracle Intermedia): it’s a option plpdf can work without Intermedia
You can try plpdf with XE.
LL
Re: PDF Generators for Application Express 2007/01/11
Hi Bob,

There is some documentation on PL/PDF here -

http://www.plpdf.com/23-927.html

and some examples here -

http://www.plpdf.com/23-4766.html

Also, you might find this useful -

http://www.plpdf.com/23-1250.html
Re: PDF rendering with PL/SQL dynamic region 2005/04/26
Dear Jochen,

Perhaps the possibilities offered by PLPDF is more suited for your type of enhanced reporting.

Take a look at http://www.plpdf.com/

Good luck, regards

Hans
Re: PL/PDF 2010/01/11
I tried everything that you described but still received the “The webpage cannot be found” error. I have all plpdf packages inside the PLPDF schema. The following program is inside the schema called VRDS_MGR and attached is the URL. Do you know what was wrong? I already granted the plpdf main package to PUBLIC. http://<server>:<port>/pls/<dad>/VRDS_MGR.TEST2 CREATE OR REPLACE procedure test2 is l_blob BLOB; begin — this program calls printer receipt through a browser Plpdf.init; Plpdf.Newpage; Plpdf.SetPrintFont(’Arial’,null,12); Plpdf.PrintCell(50,10,’Test2′); Plpdf.SendDoc(l_blob); — print owa_util.mime_header(’application/pdf’,FALSE); htp.p(’Content-Length: ‘ || dbms_lob.getlength(l_blob)); owa_util.http_header_close; wpg_docload.download_file(l_blob); end test2; / …
Re: Attaching a PDF to an automatic email 2006/01/24
For the PDF generation You can use pl/pdf See http://plpdf.com/
btw this is commercial app.
Re: Batch PDF Generation 2005/07/08
pie chart: see http://www.plpdf.com/23-930.html
and I can send bar diagram example
Re: Converting from Html DB tables to PDF. 2006/11/15
In addition to the above, PL/PDF seems to have become a more popular solution in these parts of late.

www.plpdf.com
Re: cooperation to establish pl/pdf in a demo-app 2006/10/27
we can provide a test licence to support your project. please send a mail to info@plpdf.com
Re: Create dynamic PDF or Word documents? 2005/03/10
pl/pdf (www.plpdf.com) provide easy way for creating pdf documents in HTML DB enviroment…
Re: Creating PDF file using PL/SQL 2006/01/03
Thanks Dim. I did look into this website and have emailed them with some questions. Do you use plpdf?

Rohini
Re: Fill pdf form from database table 2008/06/07
Another option is PL/PDF. http://plpdf.com/

It allows using pdf documents as templates, which can be populated programmatically.
Re: How create query based .txt, .pdf file in SQL/PLSQL 2009/07/01
You can try the Trial version of PL/PDF (www.plpdf.com) to see if it works for you.
Re: How to create pdf file based on emp data 2009/10/29
I don’t believe there is any built-in support for this kind of functionality. You may want to check out [PL/PDF|http://plpdf.com/].
Re: How to create PDF file using report tool 2009/11/02
reporting tool.

What reporting tool you are talking about here.

May be checkout [PL/PDF|http://www.plpdf.com/]
Re: Html to output pdf 2005/05/26
pl/pdf (www.plpdf.com) provide easy programming environment for creating pdf documents…
Re: Integrating PHP into my application 2007/06/07
Hi Jes,
i want to integrate plpdf-lib (http://www.fpdf.org/) in my application. Can you pls help me?
Re: PDF 2005/02/12
I’m using PL/PDF (www.plpdf.com) for generating PDF from Oracle PL/SQL….
Re: PDF Printing 2008/08/21
Hi,

You could try looking into http://www.plpdf.com/

I haven’t used this myself, but I’ve seen others on this forum recommend it
Re: PDF printing capabilities 2008/01/08
I have been using PLPDF to generate PDFs from within APEX. So far, the results have been good.
Re: PDF report from PL/SQL 2008/04/10
You can do this with Apache FOP. You may also want to look at http://www.plpdf.com/.

Mike
Re: PDF reporting? 2005/11/24
1) PLPDF is not free!
2) On OTN…could you be more specific where to look for?
THX!
Re: PL/PDF – Procedure test1 is executed but gives error 2010/04/21
Thanks for your reply,

Since the owner of header/footer procedures is different than plpdf, I should have given the grants to plpdf schema but unfortunately I missed. Thanks for the answer it worked. Instead of creating synonyms for the procedures in plpdf schema I am passing procedure name with qualifier, the name of its owner, to plpdf api (owner.procedure_name).
Re: print to PDF 2005/03/10
pl/pdf (www.plpdf.com) provide easy programming environment for creating pdf documents…
Re: Send pdf attachment with pl/sql 2007/04/11
PDF file distribution via e-mail: http://plpdf.com/23-1725.html
Re: Sending email with PDF attachment 2007/02/12
PDF file distribution via e-mail: http://plpdf.com/23-1725.html
Re: Session User 2010/04/23
Hi Varad,

as i mentioned in my thread the procedure creates a PL/PDF report – Details look at www.plpdf.com.

Regars,
Martin
multiple clobs in a single row of data 2008/06/10
I have several clobs in a single row of data and have created a procedure where I attempt to display the first 4k of each clob. using a for loop cursor I select all of the clobs in a row at the same time and then I use dbms_lob.read to get the first 4k of data. For the first lob of each row everything works fine but when I attempt to dbms_lob.read the second one I get an “ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275″ and I’m not sure why? does anyone know of an example where two or more clobs are selected and then converted to 4K varchars? sample columns for the table: SPECIALREQUIREMENTSS CLOB REFERENCERANGE CLOB ALERTVALUE CLOB REFERENCELAB VARCHAR2(50 CHAR) TESTINCLUDES CLOB LASTUPDATE DATE sample code (I removed some code for clairity – this produces the same error): create or replace procedure test_lobs as v_lab_blob blob; v_lobamt binary_integer := 32767; v_lobpos pls_integer := 1; v_labrec labman.lab_testingdata%rowtype; v_bu …
Re: PL/PDF – Procedure test1 is executed but no PDF file generated 2010/02/26
Hello All,

I got the solution only thing is that this time I tried it in APEX’s HTML region, following are the steps to do so

1. Create an HTML page
2. Create an HTML region of type PL/SQL (anonymous block)
3. Put the following code in the Region Source

declare
v_blob blob;
begin
Plpdf.init;
Plpdf.NewPage;
Plpdf.SetPrintFont(’Arial’,NULL,12);
Plpdf.PrintCell(60,20,’Hello World….’);
Plpdf.SendDoc(v_blob);
owa_util.mime_header(’application/pdf’,false);
owa_util.http_header_close;
wpg_docload.download_file(v_blob);
end;

I am new to PL/PDF, but I guess that Plpdf.SendDoc(v_blob) procedure just converts the input contents into a format that can be recognized by Adobe PDF, it can not help directly to get the PDF file as it seems to be mentioned in the installation guide.

Bhushan
Re: Drill-Down and Landscape Question – Labels 2005/11/22
Hello,

I’ve never used PLPDF myself though I know people that have and are very impressed with it. I’ve always used the XML/XSL solution but I’m pretty good at XSL (and I might be a little fond of the XML solution for some reason).

Maybe someone who has used PLPDF can chime in.

Carl
Re: FOP – how to run code in DB to read clob XML & call FOP to write PDF to 2006/07/17
Have you concidered PL/PDF?
See: http://plpdf.com/index.html?

See also:

- http://feuerthoughts.blogspot.com/2006/04/plsql-pdf-plpdf-pdf-docs-from-plsql.html
- http://technology.amis.nl/blog/?p=1135
Re: How to create pdf file based on emp data 2009/10/29
Hi Nazar,

If you need to do this frequently for a lot of users I would recommend to consider PLPDF (http://www.plpdf.com). You can download a trial version which is restricted to 5 pages of PDF + watermark but it will allow you to test whether it does what you want to achieve.

Thanks,
Erik
Re: How to find number of pages of PDF file in BLOB column. 2009/10/14
It has problem with special PDFs, example:
- incremental update: has 2 or more /Pages
- compressed object: example object deflated
- page tree: multi level tree, see example http://plpdf.com/ll/plpdf-201.pdf
I think your way is not safe…
Regards,
LL
Re: Is the PL/SQL gateway replacing MOD_PLSQL? 2006/11/07
Hi Pete,

look at www.plpdf.com – it’s great and works fine.

Look also the commet of Steven Feuerstein at http://feuerthoughts.blogspot.com/2006/04/plsql-pdf-plpdf-pdf-docs-from-plsql.html

Regards
Martin
Re: Output to PDF Document 2005/11/06
Hi Denes,

Yes you can purchase it from http://www.plpdf.com

I run an HTMLDB hosting company and lots of people require a method of easily creating PDF’s, PLPDF has been extremely easy to configure and setup to do that.
Re: Write a PDF file / Convert text file to PDF file 2007/10/24
There is a commercial tool for 600$ called PLPDF .. we are using it and I can recommend it. It generates a PDF into a BLOB and then you can send it by E-MAIL or show it via PL/SQL Web Cartridge… if you need help for the E-Mail Export I can send you the Code for it. (google for PLPDF) – it is pure PL/SQL
PL/PDF and object permissions 2007/01/20
Hi,

We are currently examining PL/PDF to generate PDF reports from ApEx.
The PL/PDF objects are installed in a separate schema (plpdf), including the “query_printing” procedure.
Now we want to use the plpdf functionality from multiple other schema’s by calling the “query_printing” procedure with a query as parameter.
So this means :
- granting EXECUTE permissions on plpdf and query_printing to all other users
- granting SELECT permissions to the plpdf user on all tables used in the query that is passed to the query_printing procedure

Is this the recommended way of working ? It seems a bit hard to maintain to me.

Thanks,
Matthias
Re: Create PDF file using PL SQL 2008/05/08
Hi,

I’ve never used this package but it looks like something that might help you. It would set you back 600 bucks though.

http://www.plpdf.com/
Re: Creating PDF file using PL/SQL 2006/01/03
No we are using FOP in our applications, but I always refused to use it

plpdf looks a lot simpler then FOP by the way (no usless XML code around…;-)

Dim
Re: export / save a page as pdf / rtf / doc format 2008/08/04
Hi Allen,

You could have a look at: http://www.plpdf.com/

I haven’t been through the blurb yet but it may be worth investigating

Andy
Re: PDF Generators for Application Express 2007/01/11
Can anyone that has coded a minor report using plpdf provide a short detailed example with APEX. The documentation assumes much……..

Thanks,
BobT.
Re: Send email attachment using htmldb_mail.send 2006/01/24
Did you check pl/pdf from http://plpdf.com/ ?

btw it is commercial app.

For the emailing part, I can’t assist you at this time -sorry

regards,
Pete
Re: Transfering BLOB from DB to XMLDB/web folder 2007/04/03
Use MOD_PLSQL to provide the results directly to a browser.
Have a look at
```
http://plpdf.com/
```
for details.

Regards, Marc
Re: XML + COCOON = PDF 2008/02/19
Hello

Yes, PLPDF might bee the answer.

But to my question is there a way to generate a xml and get this rendered in cocoon from the apex framework/or procedure call?
Re: Alternate Reporting Tool other than BI Publisher 2009/04/06
Hi,

If all you need to print is a few forms, you could consider PLPDF [http://www.plpdf.com/|http://www.plpdf.com/].

It is a bit of pain to use (you need to position all the fields individually using code), however you can use a template for the fixed elements which saves time.

It runs inside the database so nothing external to install.

I hope this helps.

Luis
Re: Any other printing engine other than FOP and BI publisher for apex? 2008/09/17
Hi Peter,

We use PLPDF for our repoting.

It is easy to install and you can do pretty much any kind of reports.

check http:www.plpdf.com

You can try it out free (but it is limited)

It is basically a bunch of procedures that you call within plsql to generate the PDF.

Licensing is per database instance and is a one time fee (I think that it is something like 500$ per database)

There are some examples for integrating PLPDF with APEX on their site.

Francis.
Re: BIPublisher free (as Apex is) ? 2008/03/31
Hi ,

We use PLPDF ( www.plpdf.com ). PLPDF is a collection of pl/sql packages that generates pdf reports. It’s easy to install. You need to pay something like 500$ per databases where it is installed for the full use license.

For sure , we would also like to use BI Publisher but the pricing is too high. They should make a runtime version for APEX for at least be able to use the advanced reporting option.

Francis.
Re: PL/PDF EXAMPLE 2007/01/20
Hi Jes,

For example, If I have a apex report that is based on a simple query such as:

Select First_Name, Last_Name, Cust_ID, Account_limit from Cust_master

If I want to generate a pl/pdf report on the above, how would I supply the above data to PL/PDF?

plpdf.init;
plpdf.NewPage;
plpdf.SetPrintFont(’Arial’,null,12);
??????
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
PL/PDF – Procedure template Example 2010/05/12
Hellow All, I have Oracle XE 10g with Oracle Apex and I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it prints template only for 1st page.How to print template for others pages. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blob blob; l_tpl_id number; begin /* Initialize template document */ template_init; /* Initialize, without parameters means: - page orientation: portrait - unit: …
Re: Drill-Down and Landscape Question – Labels 2005/11/22
Carl,

Oracle Reports has extensive .PDF output control? Yeah, that’s what I’m using, but frankly, as a new-ish person to Oracle, I HATE Oracle Reports. It seems 10 times more complicated to do things than it should be.

How does PLPDF compare to Oracle Reports from a page layout control standpoint? I checked out the website for PLPDF and was pretty impressed. I thought I’d just give someone an HTMLDB page where they’d click a button to run the report, and then they’d open the .PDF generated by PLPDF. Does that make sense? Or do you think Oracle Reports handles this kind of layout stuff just as well?

Thanks!
Steve

Message was edited by:
SteveF
Re: Printing Flash Charts in PDF 2009/10/26
I created an pilot PDF wich is containts Anychart in a PDF (see
http://plpdf.com/ll/284.pdf , it’s same as
http://anychart.com/products/anychart/gallery/sample_284.html). My problem
is the embending. I can embed only chart as URL in my pilot pdf, but I
cannot implement an full swf embending. Problem is the XMLFile parameter.
I used this URL in my PDF:
http://www.plpdf.com/ll/AnyChart.swf?XMLFile=http://www.plpdf.com/ll/284.xml
but If I can pass XML as a string then I can embed swf file into my pdf.

Regards,
LL
Re: ApEx and PDF 2006/09/30
By the way…

I just looked at the PLPDF site today and I see that they now support using existing PDF files as templates.

I’m not sure exactly what that means yet, but it sounds interesting.

I’ll try it when I get a chance.

Doug
Re: ApEx and PDF 2006/10/02
Hi Doug,
Can you let me know which section of the plpdf site gives you the template support information? I have been looking for this kind of support for a long time.

Thanks,

Ramesh
Re: ApEx and PDF 2006/10/03
use package variable for template and plpdf does not collect datas every times when you run procedure and you get faster running… (warning: PL/SQL Developer test window uses new session for every running)
Re: ApEx and PDF 2006/11/06
hi everbody,,

does anyone of you install plpdf in red hat or in other operation system than windows?? i am not used in linux at all, so i am using vmware.

thanks for help.
Re: Automatic email reports 2006/12/15
Ben,

PL/PDF is a commercial product which lets you create PDF’s directly from PL/PDF, you can read about it here -

http://www.plpdf.com/
Re: CC and BCC in the demo mail 2007/06/05
I’ve used this example http://www.plpdf.com/23-1725.html

as from here

http://forums.oracle.com/forums/click.jspa?searchID=6454479&messageID=1838715
Re: Complex PDF not with BI Publisher? 2007/05/17
Hello,

Well it depends on your definition of ‘complex’

There are other products you can use (other than BI Publisher i mean), such as PL/PDF (http://www.plpdf.com)
Re: Dynamic/Customizable PDF output 2010/03/15
Russ,

Have a look at PL/PDF: http://plpdf.com

It can do all of what you’re looking for at a fraction of the price of BI Publisher.

Thanks,

- Scott -

http://spendolini.blogspot.com
http://www.sumneva.com
Re: Export adf table to PDF 2007/12/11
Here’s another one:

http://www.plpdf.com/

The coding would be done at the database package level, and then served via a blob through the ADF / JSF. If designed right, it would give you archiving capabilities as well.
Re: PDF Report Generation using PL/SQL 2007/10/12
Hi,

Are you using any report writer if yes then it will be easy . In PL/SQL there are no packages which can help you to do that.
Check this link there is a tool written in PL/SQL.
http://www.plpdf.com/

Thanks
Re: PDF Reports 2008/08/15
Hello Zulqarnain,

another PL/SQL Package solution is PL/PDF

http://www.plpdf.com/

OK, it’s not for free. (But this was not requested in your original question …..)

Regards
Andree
Re: pdf reports in APEX 2009/03/19
There is a pure pl/sql solution at http://www.plpdf.com/.

Note I’ve never used it nor am I endorsing it, but it does not require a print server although it is a licensed product so its not free.
Re: PDF Using FOP 2005/10/18
I did. Unzipped into \oc4j\j2ee\fop-0.20.5

as the manual says. Still no chance.

I am thinking about buying this:

http://www.plpdf.com/

tool. PL/PDF

Denes Kubicek
Re: printing from Apex 2009/07/02
Depending on what output format you want to use, you can also try:
- for PDF: PL/PDF (www.plpdf.com)
- for Excel: PL/XLS (www.plsqlplus.com)

There is a Trial version available for testing.
Re: Spooling in PDF format 2009/11/12
no, it’s not… to create PDF from PL/SQL, you would need something like PL/PDF or FPDF
http://plpdf.com/
http://reseau.erasme.org/PL-FPDF,1337
Re: Where do I start to learn XSL-FO? PL-FPDF? 2010/02/08
Pl/pdf help would come from the company producing it : [http://plpdf.com/]
xsl-fo : [http://www.java4less.com/fopdesigner/fodesigner.php?info=apex]

Thank you,

Tony Miller
Webster, TX
Reports 2007/01/29
I wanna create reports in pdf or doc file. I am using XE an windows xp and I would like it to be free software… Something like plpdf but free.. Something that works with XE…
Re: ApEx and PDF 2006/10/02
Ramesh,

Take a look at the PL/PDF Template Guide here:
http://plpdf.com/23-927.html

There are some examples here:
http://plpdf.com/template_library.html

I’ve just started testing it. It does seem to work, though it runs slower using a template.
On my server, making a PDF without a template takes about .01 seconds.
With a template it takes over 1 second.

On my old PC server at home the difference is like .05s vs 10s.
Re: ApEx and PDF 2006/11/06
well actually i have never run exe file under linux, all of my life i am using windows, so my problem is how to use the exe file under linux, and to run the plpdf script, because i am using vmware,the database is under linux so i need to make a connection, to be able to use plpdf under apex.

thanks for your reply
Re: Integrating PHP into my application 2007/06/07
Hello,

i want to integrate plpdf-lib (http://www.fpdf.org/) in my application. Can you pls help me?

It looks like your confusing fpdf and PL/PDF.

You might want to look at PL/PDF http://plpdf.com/ is uses plsql and would be easier to integrate into and apex environment as it’s also base on plsql and runs in the database.

PHP would have to be set up and run on your apache instance and then you could just provide links that call a separate PHP page.

Carl

Message was edited by:
Carl Backstrom
Re: PDF Generators for Application Express 2007/01/11
Jes,

I’ve found those docs and have installed plpldf under user plpdf. I’ve tried to get the test2 example working in the manual install manual and haven’t figured it out yet. Can anyone provide specific instruction………

I’ve tried creating an anonymous pl/sql block in apex page. Created a process and inserted the test2 code there also. apex is telling me that it doesn not recognize plpdf.init method…….I’ve tried granting execute privilages but this hasn’t made a difference.
Re: Write as a pdf 2007/07/03
You can use APEX 3.0 for generating PDF out of the box. See e.g.:
Create a Master-Detail PDF Report .

Another option is the 3rd party product plpdf
PL/PDF – Procedure template 2010/05/04
Hello All, I have Oracle XE 10g with Oracle Apex and recently I installed PL/PDF in the same. I tried to execute the template procedure given in the installation guide. But it does not print data in template procedure after printing the template. How can I get the data from template procedure? The template_eg procedure is not not printing “Template Example”. - create template procedure CREATE OR REPLACE package template_eg is /* 50. Example: Templates */ procedure template_init; procedure template_eg; end; CREATE OR REPLACE package body template_eg is /* The template */ v_tpl plpdf_type.tr_tpl_data; /* Prepare template PDF */ procedure template_init is l_pdf blob; begin /* Select template PDF*/ select t.orig_pdf into l_pdf from plpdf_template t where id = 1; /* Parsing data */ v_tpl := plpdf_parser.GetTemplate( p_blob => l_pdf, p_page_id => 1 ); end; /* Procedure which use the template page */ procedure template_eg is l_blo …
PL/PDF – Procedure test1 is executed but gives error 2010/04/21
Hello All, I have Oracle XE 10g with Oracle Apex and recently I installed PL/PDF in the same. I tried to execute the headerfooter procedure given in the installation guide. But it gives error ORA-20000: ERR-006 Procedure call error: xxfooter. How can I get the header and footer from this procedure headerfooter? - create header footer procedure CREATE OR REPLACE procedure headerfooter is /* 7. Example: Header, Footer, number of pages */ l_blob blob; begin /* Initialize, without parameters means: – page orientation: portrait – unit: mm – default page format: A4 */ plpdf.init; /* Defines the page number alias. Default: {nb} */ plpdf.nopAlias; /*Sets the page header procedure name. The program name passed as a parameter executes when the page header is created. */ plpdf.SetHeaderProcName( p_proc_name => ‘xheader’, — Page header procedure name: xheader p_height => 10 — Height of h …
PL/PDF – Procedure test1 is executed but no PDF file generated 2010/02/26
Hello All, I have Oracle XE 10g with Oracle Apex and recently I installed PL/PDF in the same. I tried to execute the test1 procedure given in the installation guide. One record is successfully inserted in the Table named STORE_BLOB but then nothing is happening. How can I get the PDF file from this procedure test1? I was expecting the plpdf.senddoc(l_blob) will fetch a pop up asking me the browser path [location] where I will save the PDF file. But nothing happened… Note: I have created synonyms for all the packages in plpdf user thorugh sys user and gave grant of execute on these packages to PUBLIC. I created the STORE_BLOB table and the test1 procedure using another user and ran it on TOAD and also tried in PL/SQL developer, but no results. Am I missing something ? the test1 procedure is as below: - create table CREATE TABLE STORE_BLOB (BLOB_FILE BLOB, CREATED_DATE DATE); - create test procedure CREATE OR REPLACE PROCEDURE test1() IS l_blob BLOB; BEGIN Plpdf.init; P …
APEX PDF 2010/03/15
Is there any way to use Oracle Report server to generate PDF from APEX?

Coz, we already have license for Oracle Forms and Reports Server 10g. Also our company doesn’t want to invest on BI publisher or plpdf jus for pdf reports.

Any inputs on the above is very much appreciated.

Thanks and Regards,
Generate PDF documents from Oracle PL/SQL 2004/12/31
Hi All,
we are working on a PL/SQL project, named PL/PDF, for generate PDF documents from Oracle PL/SQL language. We are looking for PL/SQL programmers for beta testing. If you are an enquirer in this topic, please send an email to info@plpdf.com.
Thanks,
LL
PL/PDF 2008/11/27
Hi.. i’m using PL/PDF, i have run some examples that are some stored procedures of www.plpdf.com, but i don’t know how can i call the PDF that i have keep on my DB to the html page in APEX, like attach or in the page…

Somebody can help me?
pl/pdf changing size of page 2008/12/12
Hi!!

I’m using PL/PDF for generate my pdf files, but i need to generate a pdf that has the size 5″ X 8″, but i don’t know how can i do that, i tried to change the parameter in plpdf.init(), but i only found these formats A3 and A4,

Somebody can help me?..

Thanks!!
Re: Any other printing engine other than FOP and BI publisher for apex? 2008/07/20
Peter,

Take a look at PL/PDF (http://www.plpdf.com). It’s for cost, and it’s a programmatic interface to generating PDF using nothing but PL/SQL. I know many customers who have been successful with this.

By the way, you’re saying that Apache FOP is too expensive?

Joel
Re: APEX 3.1.2 / HTTP-Server 10g PDF-Printing included 2008/10/20
Hello,

Carl Backstrom blogged about using Cocoon and Tomcat to integrate PDF-printing: http://carlback.blogspot.com/2007/03/apex-cocoon-pdf-and-more.html

Cocoon should be installable on an OC4J instance.

Another alternative is using PL/PDF: http://www.plpdf.com/

Hope this helps,
Dirk
Re: Batch PDF Generation 2005/07/08
PL/PDF:
1. You can use PL/SQL for batch generation
2. PL/PDF can stores PDF files in database (archiving)
3. You can schedule (DBMS_JOB)
4. You can distribute via e-mail (see http://www.plpdf.com/23-1725.html)
Re: can we create pdf files from oracle using UTL FILE 2007/03/05
Hi!
you can see the following link —

http://forums.oracle.com/forums/search.jspa?threadID=&q=how+to+create+pdf+from+pl+sql&objID=f75&dateRange=all&userID=&numResults=15 .

And also — http://www.plpdf.com/ .

Hope this will help u a bit.

Regards.

Satyaki De.
Re: create PDF from data in database 2007/06/13
I’ve found this site
http://plpdf.com/index.html

but I don’t know if It’s free.

So, if you programming in asp code, there’s a class called fpdf (derivated from the same class in php).

If you need, I can give you the referred.

Adios
Paolo from Madrid
Re: Create PDF from PL/SQL 2007/09/03
There is a third party oracle package available in this site -

http://www.plpdf.com/

But, you have to pay for it.

Regards.

Satyaki De.

N.B.: or you’ve to write it in JAVA – which is not a easy task again and then call that method using any Oracle procedure.
Re: Export to PowerPoint 2006/06/19
Hello,

Well you can get PDF pretty easily by either the FOP solution or using PL/PDF.

http://htmldb.oracle.com/pls/otn/f?p=18326:44:9731321528050548068::::P44_ID:1522
or
http://www.plpdf.com/index.html

Carl
Re: FOP – call fop from db, write pdf to OS using only java & plsql in db 2006/08/22
I have re-read you initial entry. What was your decision not to use http://plpdf.com/23-1015.html ? (same amount of money and 1 year support). See also the discussion on my employers site at http://technology.amis.nl/blog/?p=1135
Re: How to Convert a page and save as PDF / .Doc file in local drive 2006/08/02
One way to do this would be to integrate with XML publisher, and another would be to try the PL PDF http://plpdf.com/23-4122.html. We hope to have this functionality native with APEX 3.0, but now we have no integrated PDF printing capablity.

Hope this helps,

Mike
Re: html db to display pdf files saved as blob in the data base 2006/10/25
we use:

owa_util.mime_header(’application/pdf’,false);
htp.p(’Content-Length: ‘ || dbms_lob.getlength(l_blob));
owa_util.http_header_close;
wpg_docload.download_file(l_blob);

see plpdf.com
LL
Re: pdf printing in interactive report 2010/04/27
Hi,

You can also use PL/PDF which costs $600 or BI Publisher which costs a lot more.
I’ve used PLPDF and it works quite well it consists of PLSQL packages.
There’s lots of threads on this and it’s worth searching the forum.

Regards,
Chris
Re: PL/PDF – Procedure template 2010/05/04
This really has nothing to do with Oracle Reports. I think you can only get support for pl/pdf if you have a licensed version: http://support.plpdf.com/oc/helpdesk.php

Just as a hint: this procedure produces output to your browser. Are you calling the correct URL for this procedure?
Re: PL/PDF – Procedure test1 is executed but no PDF file generated 2010/02/26
Hello Michael,

Thanks for the reply,

But I really did not understand that the plpdf.senddoc(l_blob) will output the pdf document as inline to the browser,
since the procedure did not contain settings for any mime type or content type.

Also the plpdf.senddoc(l_blob) has a OUT argument parameter of BLOB data type. So it is expected that it will ask it to store as a file of desired file type, here it will be .pdf

or

we can manipulate the l_blob variable contents using other Oracle Packages like dbms_lob or utl_file to store the LOB contents.

I checked the FAQ in the PL/PDF support will again check for other links… thanks

Bhushan
Re: Print Bill 2009/12/14
Actually you sent a gif or jpeg file in a word document.. I would HIGHLY recommend you look at either BI Publisher (http://www.oracle.com/technology/products/xml-publisher/index.html) or pl/pdf (http://plpdf.com/) to build a template for this document..

Thank you,

Tony Miller
Webster, TX
Re: Reports: Displaying master detail information 2006/09/05
Bill: My take-away from this thread was “use the right tool for the right job”. Generating pixel-perfect print media output, business documents like invoices, receipts, etc are best done using a dedicated reporting tool like the ones I mentioned earlier.

People have used FOP solution or PLPDF (http://www.plpdf.com) and the like to generate PDF output from Apex but they all look very cumbersome to me. I would prefer to wait for the Apex 3.0 release which promises to have native PDF report generation.

Thanks.
Re: Send E-Mail with attachment from HTML DB 2006/07/20
Hi again,

Please note:
The method mentioned above is not officially supported anymore for 9i and 10g database.
Anyway it still works with these releases also.

Another Method is described on

http://www.plpdf.com/23-1725.html

regards
Thomas
Re: Send emails with pdf 2007/04/27
Felipe,
Here is a link to do exactly that. http://www.plpdf.com/23-1725.html
I have used it and it works very well sending all types of documents (including word and excel which I uploaded to the server).
Keep Smilng,
Bob R
Re: Sending an email with an attachment 2007/05/23
Have a look at http://www.plpdf.com/23-1725.html maybe that example helps you.

Patrick

My APEX Blog: http://inside-apex.blogspot.com
The ApexLib Framework: http://apexlib.sourceforge.net
The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/
Re: Sending blob attachments via email from apex 2007/05/10
Hi Federico,

have a look at http://www.plpdf.com/23-1725.html

Patrick

Check out my APEX-blog: http://inside-apex.blogspot.com
Check out the ApexLib Framework: http://apexlib.sourceforge.net
Re: Transforming to PDF 2007/09/11
There is still a commercial version here (http://plpdf.com/index.html) for generation pdf via pl/sql.

Mark has given an example of how to generatie html from stored pdf here: http://forums.oracle.com/forums/thread.jspa?messageID=1993123&#1993123
Re: Word Email Attachment 2007/03/25
Hi Bob,

I think the following example covers what you are looking for

http://www.plpdf.com/23-1725.html

Greetings
Patrick

Check out my APEX-blog: http://inside-apex.blogspot.com
Check out the ApexLib Framework: http://apexlib.sourceforge.net
Re: would like print out invoices directly from apex application 2006/05/10
You have lots of options, fac586 gave a perfectly reasonable response to your question (in that you can format your pages using CSS so that they will be easier to print).

You can also look at FOP and (my recommendation) PL/PDF (www.plpdf.com) for easily creating PDF invoices from your application.
Re: XML + COCOON = PDF 2008/02/18
Hello,

I don’t have a direct answer to your question, but if you are a skillful pl/sql developer, you should check www.plpdf.com . It can be a good solution to your problem, and maybe your project budget can stand it.

Regards,
Arie.
Re: Dynamic/Customizable PDF output 2010/03/19
Good news…

pl/pdf v2.1 seems to support turning xhtml source into PDF (plpdf_xhtml package).

I have previously used the Apex “HTML editor standard” item type to edit and store HTML that I parse and replace tokens within the HTML to create customized emails.

I’ll use the same technique to allow the user to design/layout the report in the HTML editor. Then I can parse/replace the tokens and pass the resulting HTML to plpdf_xhtml.xhtml_to_pdf routine which returns a PDF BLOB.

Only significant question remaining is how tough is the validation of the XHTML and can I pre-validate the HTML entered by the user will be sufficiently valid XHTML.

Thanks for the lead on pl/pdf and I’ll update this thread as I experiment…

Russ
Re: Print custom Reports without Oracle BI 2007/09/27
Hi,

You have at least 3 options -

1) Full BI Publisher (i.e. Advanced Printing).

2) Standard Printing.

3) “Other method”, such as using the PLPDF package (http://plpdf.com).

Remember though, even standard printing is capable of producing extremely complex reports however you need to do a lot of the work yourself (rather than using the nice Word/Excel etc plugins that the BI Publisher desktop tool gives you). To make complex reports with Standard pritning you’re going to need to drop down to producing the XSL-FO yourself (or at least find some way of generating the XSL-FO that will produce the report format you desire).

I recently showed someone how easy it was to generate a chart in a PDF using only standard printing, it’s really not as complex as it looks at first glance.

John.
Re: question on images 2006/08/30
Rabbott, Thank you so much for pointing out the errors. I would double check the BFILE and dbms_lob package. I have another question that relate to oracle interMedia performance. I’ve create a procedure that will display images on plpdf using oracle interMedia to convert images file format to “jpeg”. But somehow, the performance taking so long to display the image, eventhought, the image is just 26469 in size. Especially two lines taking a lot of time in my procedure are: — Convert Image file Format to JPEG l_image.process(’fileformat=JPEG’); local_blob := l_image.getcontent(); Below is entire procedure code that use to display image: create or replace temptest (p_id number) as l_image ORDImage; convert_image ORDImage; l_blob blob; local_blob blob; start_time binary_integer; total_start_time binary_integer; end_time binary_integer; total_end_time binary_integer; begin total_start_time := dbms_utility.get_time; start_time := dbms_utility.get_time; …
Create PDF from PL/SQL 2007/09/02
Hi,

I am using http server with dad configuration to call my procedure. I need to generate a report in pdf format using pl/sql. Can anyone tell me how to do this, i got many result with this search to use FOP or plpdf. Does oracle has any built in packages to create pdf from pl/sql. My database is 9.0.2.5

For example if i call the procedure using http i need the output in pdf format
http://localhost:7777/dad/procedure name

Regards
progress bar question 2007/11/09
Hi,
I have the code from Carl to make the progress bar work with a URL redirect,
http://apex.oracle.com/pls/otn/f?p=11933:62
and it works great.

But,
I have a button that branches to page 11 to generate a PDF (plpdf process), is there a way that I can fire this progress bar function on a branch to page when I click the button? If so, where would I put the: javascript:html_Submit_Progress(this);?

thanks,
dirk
Re: About Report 2007/02/15
Apex does not as yet support PDF printing out of the box. At this stage your options are;

1. Wait for the release of Apex 3.0 (evaluation instance is now available).

2. Use FOP to generate PDF output (probably not for a novice user). See this link;
http://www.oracle.com/technology/pub/notes/technote_htmldb_fop.html

3. Purchase a product such as PL/PDF
http://www.plpdf.com

cheers,

Ron
Re: Add watermark to pdf stored in a table 2008/10/27
Hello,

Take a look at PL/PDF (http://www.plpdf/com), they provide tools to do that (the PL/PDF Toolkit).

Hope this helps,

John.

Blog: http://jes.blogs.shellprompt.net
Work: http://www.apex-evangelists.com
Author of Pro Application Express: http://tinyurl.com/3gu7cd
REWARDS: Please remember to mark helpful or correct posts on the forum, not just for my answers but for everyone!
Re: Any other printing engine other than FOP and BI publisher for apex? 2008/07/21
Peter,

Take a look at PL/PDF (http://www.plpdf.com). It’s
for cost, and it’s a programmatic interface to
generating PDF using nothing but PL/SQL. I know many
customers who have been successful with this.

By the way, you’re saying that Apache FOP is too
expensive?

Joel

You could also look at jreports.. few threads are here that show how to integrate it with APEX..

Thank you,

Tony Miller

PS: Maybe Oracle will pickup on the demand that is here for a low cost alternative to BI Publisher that offers more features than FOP..
Re: APEX for XE and PL/PDF 2007/01/09
Hi Kris,

Thanks for the fast response!

Your reference is for writing the blob to the filesystem (which is a great reference), but I was after a a process that will display the blob (pdf in my case) to the user client, ideally without going to the filesystem first using utl_file, although I will do this if I absolutely have to…

Blob in Database (Created by plpdf in XE) -> Displayed in APEX (no modplsl component)

Cheers

Jon
Re: Code 39 Barcode 2009/01/23
I can think of a couple of ways to do this off ot the top of my head:

1) Install a Code 39 Font, and then render your reports using that font. You will, of course, need that font installed on all machines that need to view the barcode.
2) Look at PL/PDF: http://plpdf.com/barcode.html It’s a PL/SQL based API for creating PDF documents from the Oracle Database. It works nicely with APEX, and also supports Code 39 barcodes.

Hope that helps!

- Scott -
Re: Customized PDF 2008/11/26
Ok, i understand all is happening here, the server that i’m using has installed PL/PDF, i think this is independent of XLS-FO, i have created a PDF with a stored procedure, but i don’t know how can i show these in my APEX pages…

I have read the examples in www.plpdf.com, but i can’t show the PDF file for download or in the page..

somebody have an example about it?..

Thanks!!
Re: Drill-Down and Landscape Question – Labels 2005/11/22
Hello,

I doubt your going to be able to get the right output using HTML DB directly. It’s not an HTML DB issue but an issue with poor printer layout capabilities of HTML in general. Your probably going to want to look into the different pdf printing solutions so you can get exact layout that are available like,

http://plpdf.com/

or

http://www.oracle.com/technology/pub/notes/technote_htmldb_fop.html

Carl
Re: Drill-Down and Landscape Question – Labels 2005/11/22
Carl,

Thanks a million for all your help. But does Oracle Reports have the same kind of control? I know it has some, as you can move items around on the page, but I’ve avoided it as much as possible as it seems a lot more complicated than it could be. I guess I’m wondering if I Oracle Reports could handle this fairly easily.

As far as PLPDF goes, it looks pretty good and fairly straightforward, that’s why I thought it might be the way to go…

Thanks.
Steve
Re: Generating a pdf form from oracle 10g databse. 2009/05/04
Hi, try this:

1.- Generate dynamic PDF documents from data stored in Oracle databases using the PL/PDF program package. [www.plpdf.com]

OR

2.- PDFCreator easily creates PDFs from any Windows program. Use it like a printer in Word, StarCalc or any other Windows application. [http://sourceforge.net/projects/pdfcreator/]
Re: How create query based .txt, .pdf file in SQL/PLSQL 2009/06/24
Andreas Weiden wrote:
There is a commercial tool called plpdf, but i can’t tell if its good.
.
Also possible would be to create an XML-FO with sql or pl/sql.
And then use Apache-FOP to convert the XML-FO into a pdf, rtf or whatever you want.

No extra costs but the effort to learn a bit about the fo elements/syntax.

I think the newer Apex-Versions can doing something like this also. Maybe additionally ask in the Apex Forums.
Re: How to Print Using PL/SQL 2006/07/06
well i have found out a program from internet. can we approach this problem in this way. i dont know is it the perfect answer on not. just a wild guess.

here is the link
http://72.14.209.104/search?q=cache:6J2gsNu1vawJ:plpdf.com/+how+to+print+using+PL/SQL&hl=en&gl=in&ct=clnk&cd=2
Re: Mail Merge ? 2005/11/04
Tom,

Your requirements are 100% do-able in HTML DB. You may want to upgrade to 1.6 or even 2.0, as there are some new features in those releases which will make your overall development easier.

Your most difficult task will likely be the printing of the document, especially if you don’t have FOP available. You may want to take a look at PL/PDF (http://plpdf.com), which is a PL/SQL-based engine which generates PDF files.

Good luck!

- Scott -
Re: Mail Merge and Microsoft Word 2007 2008/01/19
Hi Vojin,

Just wondering if you already had a look at BI Publisher.
It integrates nicely with APEX (see http://dgielis.blogspot.com/2007/12/call-bi-publisher-report-from-apex.html)

It’s not free and it costs a lot more than PLPDF, but it’s very easy and I think it can do everything you want to do…

Dimitri
– http://dgielis.blogspot.com
– http://apex-evangelists.com
Re: Merge multiple PDF docs into one PDF 2009/07/17
plsqlplus wrote:
Try PL/PDF Toolkit.

Judging by [this user’s profile | http://forums.oracle.com/forums/profile.jspa?userID=706717 they are an agent for [PL/PDF | http://www.plpdf.com/. Which might be contrary to the forum’s terms of use but doesn’t necessarily invalidate their advice. The company offers a trial download of the toolkit so you can see whether it solves your problem before springing for a USD300 license.

Cheers, APC

blog: http:/radiofreetooting.blogspot.com
Re: Output to PDF Document 2005/11/06
You can find an cost-free solution here:

http://www.oracle.com/technology/pub/notes/technote_htmldb_fop.html

but this is not alwas easy to set up. At least I coldn’t manage that.

Here you will find a solution you need to buy. But I heard that it works better than
the first solution:

http://www.plpdf.com/

Denes Kubicek
Re: PDF printing capabilities 2008/01/08
Hi

I took a look a while ago at PLPDF and it seemed quite good indeed. The problem is that (as I understand it) the reports need to be rewritten, you cannot just add a link to an Apex page and have magically it converted to PDF using that tool… or can you?

I guess you have PL/SQL processes that call procedures in the DB that generate the PDFs and return them, without any other integration with Apex?

Luis
Re: PDF Printing without Oracle BI Publisher and OC4J 2008/11/10
Hi guru,
This was the reply I had got for posting the same question some time back.
Pdf printing option without using BI Publisher can be done using PL/PDF (http://www.plpdf.com) which provides a programmatic way to generate PDF documents (it doesn’t produce Word docs as far as I’m aware however).
Re: PL/PDF EXAMPLE 2007/01/20
Hi Bob,

There are many many different ways to achieve that, but if you want a ‘quick’ way of doing it, then something like -
```
query_print.query_print_01(

  'Select First_Name, Last_Name, Cust_ID, Account_limit from Cust_master', 

  8,

  1);
```
I really suggest having a look at the examples and documentation here -

http://www.plpdf.com/23-925.html
Re: Print multiple page report 2006/03/14
That is about all you can do. A web application, a thin-client only knows about what it sees in the current page view.

Some alternatives you could evaluate to print the entire report are

a. FOP (export to PDF); search the forum for more information
b. export to CSV and then print from Excel
c. change rows/page to a large number (as you point out) and then use the browser’s File/Print feature
d. use a commercial product like http://www.plpdf.com
Re: print to PDF 2005/03/11
Joel,
thanks…
My answers:
1. my team (and me) created this util, we are working on our sales plan.
2. we don’t have enough resource for our all development plans, but we support 18 encoding types. UTF-8 is the future.
3. We support the TTF font embedding from font file.
4. plpdf_util is not wrapped package, you can use other method for printing.
Laszlo
Re: Printting 2007/05/07
Syed,

With APEX there are a few options:

- APEX 3.0 supports PDF printing (see http://www.oracle.com/technology/products/database/application_express/html/3.0_new_features.html)

- You can purchase and install PL/PDF (see http://plpdf.com)
- Search this Forum for “PDF” to see other open source options, such as FOP

Thanks,

- Scott -
Re: question regarding outputing results of query to pdf file 2006/03/09
This is not possible without some additional software and/or development.
I believe that Oracle Reports gives you this capability.
I have heard good things about PL/PDF, but have never used it (http://www.plpdf.com)
I have used the Apache XSL-FO java libraries, but this requires substantial development (http://xmlgraphics.apache.org/fop/)
I have heard that the next release of Oracle Application Express (formerly HTMLDB) may have this capability.
Re: Reading a .doc file by pl/sql 2010/04/20
Using <Insert Search Engine Here> is probably the best place to start. Only took me a couple of minutes to find these:

PL_FPDF
PL/PDF
Microsoft Word Demo
Re: send mail instead of/by printer friendly 2008/01/29
Hello,

What is it exactly that you’re trying to do? If you want to email the report to a recipient rather than printing it, then using BI Publisher you can achieve this (emailing reports out), alternatively take a look at using PL/PDF (www.plpdf.com) which enables you to produce a PDF which you can then email out.

Hope this helps,

John.

http://jes.blogs.shellprompt.net
http://apex-evangelists.com
Re: form to pdf convesion in apex3.2 2010/03/10
Hi: Printing to PDF is not an ‘out of the box’ functionality in Apex. You have a number of options though, and none of which are too difficult. If you simply want the user to be able to produce and manually print a pdf file, you can install one of the many free PDF printing tools such as CutePDF. When the user prints, they simply select this as their printing device and it generates a PDF file that they can save to their local machine or pint. It is basic – but it works. Alternatively, the very best but most expensive solution is to use the BI Publisher suite rom Oracle. This requires a user liscence. Details of how to integrate this are at: http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html A less expensive, but still costs approach is plpdf which is a plsql library of procedures for creating and printing pdf documents. You can find further details at: http://www.plpdf.com Ahother, cost free, solution is to use Apache and Cac …
Request suggestions for PDF printing of forms such as paychecks, W2's 2010/03/01
This question is on two levels. I see this as an up and coming project at work, and even there I doubt we will be purchasing BI Publisher as we are in cutback mode. More inportantly, for my own clients who want an application on the cheap. I have seen posts about PLPDF. I would consider it, but then I am not sure who could host the application with the condition of needing plpdf as a requirement. I have looked at FOP, and even installed it. Like many others, I don’t have a lot of xslt formatting experience, and a cheap or free tool for creating a report format would be really helpful. Having to purchase a $600 tool really cuts into a $1000 dollar project. What are available options? The key concept is I am trying to replicate other people’s forms in PDF, such as W2’s and Paychecks, so the look and feel has to be professional. Way back in the day, I would write a Visual FoxPro app that used Crystal Reports to format the report. It wasn’t too difficult to write applications fo …
Re: Email with Attachment 2007/07/25
Saurabh,

your mail package reads the attachment from the file system, but you have stored them in a table.

Have a look at the following mail package at http://www.plpdf.com/23-1725.html
which excepts a BLOB as input parameter.

The only thing you have to do is to read it an pass it when you call the procedure.
```
DECLARE
file_name varchar2(100);
mim_typ varchar2(50);
vBlobContent BLOB;
begin
select name, MIME_TYPE, BLOB_CONTENT into file_name, mim_typ, vBlobContent from dumy_file where id = :P2_X;
call_to_mail_package
  ( ... other parameters ...
  , p_blob => vBlobContent
  );
```
Patrick

Re: Output pdf to blob 2010/04/02
See the FAQ’s from PL/PDF’s website (http://plpdf.com/#/support/faq) in particular:

What can I do with the generated PDF file?
    PL/PDF returns the PDF file in a BLOB variable. This return value can be used in the following way:
 
    * Store the BLOB variable containing the PDF file in the database to display later or to archive.
    * Display the PDF file in a browser using a Web Server that has MOD_PLSQL capabilities.
    * Send the PDF file as an e-mail using PL/SQL’s mail extension.
    * Save the PDF file to a computer.

Thank you,

Tony Miller
Webster, TX

Re: PDF printing in 2.0 2007/06/28
Hi Markus, the viewlet is available at http://carlback.blogspot.com/2007/03/apex-cocoon-pdf-and-more.html , but I’m not sure if that really works with APEX 2.0. If i’m not wrong Cocoon gets it’s raw data as XML stream, so you would have to write that in APEX, because only 3.0 does it automatically. For an alternate solution you can also have a look at http://www.plpdf.com/ Patrick My APEX Blog: http://inside-apex.blogspot.com The ApexLib Framework: http://apexlib.sourceforge.net The APEX Builder Plugin: http://sourceforge.net/projects/apexplugin/ …
Re: PL/PDF 2008/11/28
Hello, Did you create a procedure that generates your plpdf? You can call that procedure directly from the browsers url for ex http://localhost:port/pls/apex/SCHEMA.PROCEDURE You would need to grant execute to public and call your procedure in capitals (with the user). If you’ve parameters you can use ?param1=…&param2=… If that works you can call that url from a button for ex. in APEX Regards, Dimitri http://dgielis.blogspot.com/ http://www.apex-evangelists.com/ http://www.apexblogs.info/ REWARDS: Please remember to mark helpful or correct posts on the forum, not just for my answers but for everyone! …
Re: Printing out a report in Apex 2008/05/23
Prohan, Go to http://www.plpdf.com/, on the main page they put an helloworld exemple. If you search the site, you’ll find exemple specific for apex (htmldb… they use the old name). I won’t detail much because everything you need is on their site… search and read! 1) Download the demo version 2) Try the helloworld exemple 3) Modify the helloworld exemple to show data from your DB. 4) Create real package 5) If you are happy with the result, buy a license, and get an happy client Louis-Guillaume Homepage : http://www.insum.ca Blog : http://insum-apex.blogspot.com …
Re: Rendering Oracle HTML DB Reports as PDFs Using FOP 2005/03/19
For those that have an aversion to JSP’s and Java, have you considered integrating HTML DB with either:

1) Adobe’s Document Server Product (similar to FOP), or
2) Oracle’s XML DB functionality, which appears to cleverly integrate XML, XSLT’s and create PDFs. And it does not appear to have a Java dependency.

If HTML DB will NOT integrate with either of the possibilities above, then either Oracle’s XML DB product, or PLPDF would appear to be preferred alternatives for those who strongly prefer PL/SQL over Java (which I assume is a majority of HTML DB users). However; it would sure be nice to be able to do everything through HTML DB.
Re: Shared component Report Queries 2008/09/01
Hello, If you can go for BI Publisher that would be very nice and integrates awesome. To install and configure you can follow this: http://dgielis.blogspot.com/2007/06/testing-oracle-bi-publisher-with-apex.html There’s also a guide of Oracle here: http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html If you can’t go for BI Publisher, you can use Apache FOP for ex or PLPDF (but that’s something totally different from the other two) Regards, Dimitri http://dgielis.blogspot.com/ http://www.apex-evangelists.com/ http://www.apexblogs.info/ …
Re: Active Directory and LDAP 2008/05/21
Hi Scott,

here the values of each value in my authentication scheme set with values (don’t know the exact wording since I have a german translation):

NAME: CUSTOM_SCHEMA

SUBSCRIPTION: – (Checkbox Refresh is checked)

SESSION NOT VALID (PAGE): 101

AUTHENTICATION FUNCTION: RETURN username_password_check; (The above described function)

LOGOUT URL: wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1

As mentioned all other fields are empty.

What procedure over URL?

In another project I used PLPDF to generate PDFs by clicking on a button. Therefore I had to modify the wwv_flow_epg_include_mod_local function in the FLOWS_XXXXX scheme to allow my print function to be called over a URL.

Andreas
Re: APEX Downloadable Reports 2009/01/14
Hello, Like you said BI Publisher would be the easiest option, but you are doing that report in xsl-fo then? You can use variables in xsl-fo too for ex.: <xsl:variable name=”var1″>…</xsl:variable> If that is not enough, have a look at Saxon. We had to use that in a project to be able to make things more generic. But I would need to digout the example again to remember what it was exactly. XSL-FO can be a real nightmare at some points to be honest. If it takes too long to get the result in XSL-FO I can also recommend PLPDF. Regards, Dimitri http://dgielis.blogspot.com/ http://www.apex-evangelists.com/ http://www.apexblogs.info/ REWARDS: Please remember to mark helpful or correct posts on the forum …
Re: Automatic email reports 2006/12/15
Ben Firstly PL/PDF ( http://www.plpdf.com/ )is not free, you have to pay for a license. This may or may not be appropriate. Try looking at my colleagues blog at http://www.benjaminwootton.com/ . I believe that you can combine the technique he outlines with the scheduling packages built into the db and apex. You may want to look at APEX_PLSQL_JOB and possibly the article at ( http://www.oracle.com/technology/obe/obe10gdb/manage/scheduler/schuser.htm) which takes a different approach. I’m sorry I can’t point you in any other direction or give you a more specific/direct answer but I was actually looking for a solution to a problem I am encountering when I stumbled across yours. Hope it was of some help anyway. Kris Message was edited by: Kris Jones …
Re: How to create pdf file using oracle procedure 2009/03/27
using oracle reports is your best choice, given it is included in the same license but if you would consider, there is pl/pdf (www.plpdf.com), which will allow you create pdf docs by using pl/sql – it is a commercial product but not too expensive. If you are on Forms/Reports 6i client/server – then definitely use Oracle reports. If you are using iDS/iAS then you might need to look into utilizing SSO (single-sign on) for forms/reports integration and SSO is part of the Enterprise Edition license of the iAS. There is a relatively new white paper on OTN regarding passing parameters between forms and reports by utilizing the cookie method. If only Forms and Reports are installed (and if you don’t need SSO) then this document might be helpful. The licensing for Forms/Reports only installation of iAS also will be little cheaper.
Hope this proves useful.
R/ Zafer
Re: How to download a record as a pdf/word document? 2008/10/22
Hello, APEX supports PDF printing using either Oracle BI Publisher or Apache FOP (or another print engine such as JasperReports), you can read more about the PDF Printing here - http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html Essentially you can create a template for your PDF/Word output and then supply that template with whatever dynamic data (for example your records) that you wish to include at runtime. Another option is to use PL/PDF (http://www.plpdf.com) which provides a programmatic way to generate PDF documents (it doesn’t produce Word docs as far as I’m aware however). So the answer to your question is yes, but you’re going to need to read up a bit on it. Hope this helps, John. Blog: http://jes.blogs.shellprompt.net Work: http://www.apex-evangelists.com Author of Pro Application Express: http://tinyurl.com/3gu7cd …
Re: How to generate report 2008/09/20
Hello, Application Express has extensive support for printing, take a look at these links - http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html http://download.oracle.com/docs/cd/E10513_01/doc/appdev.310/e10497/pdf_report.htm#BABFAJII You can use BI Publisher or FOP (which is free) as your printing engine, or you can also use a 3rd party package like PL/PDF (http://www.plpdf.com) which allows you to generate PDF’s in a programmatic way. Hope this helps, John. Blog: http://jes.blogs.shellprompt.net Work: http://www.apex-evangelists.com Author of Pro Application Express: http://tinyurl.com/3gu7cd …
Re: PDF Format EXPORT in 3.0 vaesion is it posssible, or is there any solution 2008/08/30
Hello, Sure, take a look at the PDF Printing document here - http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html Basically you can either use BI Publisher (which costs money) or Apache FOP (which is free) as your printing engine, that link shows you how to configure them. Alternatively you can use a pure PL/SQL method like PL/PDF (www.plpdf.com) which is a more programmatic way to create the PDF’s but does not require a print server to be setup. You can also use a product like JasperReports too. Hope this helps, John. http://jes.blogs.shellprompt.net http://www.apex-evangelists.com …
Re: PDF printing capabilities 2008/01/08
Hi Luis,

You can create some incredibly complex and rich reports using the BI Publisher (BIP) integration that APEX allows. In your report template (using the BIP plugins) you can use conditional logic to make colour columns/rows etc depending on certain criteria.

It is possible to do this yourself using the (free) Apache FOP solution, however it involves a great deal of hand-crafting the XSL-FO code yourself (not a task to be taken lightly, but entirely possible).

If you have the budget for it (or your requirement is urgent), then I highly recommend using BIP, if you don’t have the budget then I recommend Apache FOP and a bottomless coffee pot and ready access to a local bakery (you’re going to need the caffeine and sugar to get you through the manual XSL-FO coding).

Another possibility is to investigate PL/PDF (www.plpdf.com) which might suit your needs.

Hope this helps,

John.
Re: print friendly 2008/08/28
Hello, Yes, absolutely. Take a look at the PDF Printing guide here - http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html You can use either BI Publisher or another Print Engine, such as FOP to produce PDF, Word, Excel, etc types of output from your application. It might look complex at first, but really once it’s setup and you’ve done a couple of examples the printing functionality is extremely powerful and flexible. Another option is to use a pure PL/SQL printing solution like PL/PDF (www.plpdf.com) which can work extremely well too. Hope this helps, John. http://jes.blogs.shellprompt.net http://www.apex-evangelists.com …
Re: print to PDF 2005/03/10
Laszlo,

This is very cool.

A handful of questions/comments if you don’t mind:

1) What do you charge for this? I can’t seem to find this on your site.

2) Is there any reason why you don’t support utf-8 or any Asian character sets for the p_enc parameter of SetEncoding?

3) A likewise question for p_family of SetPrintFont. To support printing of Chinese, Korean, Japanese, etc. you might need to expand the list of fonts supported.

4) Not a question but a comment…in plpdf_util.print_blob, you may wish to use wpg_docload.download_file to emit the BLOB instead of the logic you have there. Due to the buffering and character semantics of the PL/SQL Web Toolkit, you could inadvertently chop up multibyte/binary data using htp.prn (this is speaking from experience).

Joel
Re: Send printer friendly page per mail 2008/07/31
Hello Carsten, >> That’s the point! I don’t have BI Publisher. That’s OK. You don’t have to, and just for printing a letter like page, you probably don’t need to. APEX also supports the standard printing configuration, which supports the PDF format, using Apache FOP – http://www.oracle.com/technology/products/database/application_express/html/configure_printing.html#2.1 – or Cocoon – http://carlback.blogspot.com/2007/03/apex-cocoon-pdf-and-more.html. These are free, server side solutions that you can use. If you have some higher demands, but still can’t afford/justify the BIP solution, you can check a commercial solution like PL/PDF – http://www.plpdf.com/. If your application environment and needs allows it, you can also use a client side solution. There are several PDF drivers, which are much cheaper then server side solutions, which can also help you. Regards, Arie. …
Where do I start to learn XSL-FO? PL-FPDF? 2010/02/08
Hi All,
I am without work right now so I want to learn about XSL-FO
and PLPDF etc. to be able to manipulate report downloads as PDF.

Where do I start? Is this the right forum?
Where do I find the best “How To’ on Report Queries and Report Layouts?
I went to http://reseau.erasme.org/PL-FPDF,1337 and see the following is required.
I have XE installed but that won’t include OrdImage correct?
does my APEX Workspace on Oracle.com have OrdImage installed so I can try to get this working?
What about URIFactory??

Oracle en version 10g (10.2.0.1 and above).
Installation ofOracle Web Tool Kit required (owa, htp and htf packages).
OrdSys.OrdImage required (Oracle cartridge for images).
Installation of package URIFactory required.

thx Ron
Re: APEX 3.1 Enhancements 2007/06/26
Just got back from ODTUG in Daytona Beach,FL. Excellent conference. There was a lot of buzz and a tremendous amount of energy surrounding APEX. This is the most energized ODTUG conference in years. According to Mike Hichwa 3.1 should be downloadable from this site this week. Couple of enhancements for 3.2 – Improved Export to csv/spreadsheet. Current csv export is very limited in terms of data formatting and protecting (text not numbers and/or dates). Have downloaded and implemented Tom Kyte’s excellent owa_sylk package. Of course this means I need to write 2 queries – one for the html output and one for excel. Something like this should be integrated into APEX. When I say integrated I mean just like one enables the CSV output and link on the report attributes page today. – Easier PDF printing. Have implemented FOP on the 10g app server but unhappy with the output. I’m getting lines and text smashing into each other. Still going to Oracle Reports for nice PDF output. Of course …
Re: email the present page 2008/10/24
Hello, It’s possible in a number of ways. You could create a report template which ‘mimics’ the layout of your page, which you pass any custom data to (just like a regular report template). You can use either BI Publisher or FOP to do this. Then you can use the apex_util.get_print_document routine to create a PDF blob of your report, which you then pass to the apex_mail.add_attachment routine to add as an attachment to your email. That’s definitely one solution (we use it), another option would be to use PL/PDF (http://www.plpdf.com) to programmatically create your PDF and then email it. Another option is to call a webservice which takes a ’snapshot’ of your webpage (there are a few around) and then email that. So…simple? Not super-simple no, but not that much work either. Hope this helps, John. Blog: http://jes.blogs.shellprompt.net Work: http://www.apex-evangelists.com Author of Pro Application Express: http://tinyurl.com/3gu7cd REWARDS: Please remember to mark helpful or …
Re: Enhancement Request Thread : Post 3.1 2008/08/13
Hi, I know I am a bit late but anyways, here are some things that we would like to see in the next release : 1.Add the language in the url parameters ex : f?p=1:1:00000000:::::en-us This way, we could call a page in a specific language. 2.Make the Upgrade Process of APEX to run without any downtime. 3.In the Support Objects, include the translation. So when we import an application , the translated apps would also be part of it. Would be also nice to be able to translate an application via sql developer for run-time only 4.Add some features for Seach Engines. Session 0 is a nice feature but being able to add tag clouds or other things that would help being indexed would be really great. 5.Authentication via SSO for the Developpers (for workspaces) Instead of having to manage the same users over multiple workspaces. 6.Easier PLPDF FOP implementation. (It is complicated to install OC4J and FOP) 7.** not a feature but still ** Runtime pricing for Bi Publisher license when used …
Re: PDF merge 2010/04/16
Doug, Here is the link: http://plpdf.com/ I have used Oracle Reports (since we already have Oracle 10gAS for the reason of some older applications in Oracle Forms), PL/PDF, and Apache+Cocoon to generate PDF output from Apex. We cannot afford BI Publisher because of its price in terms of reporting. I wouldn’t recommend Oracle Reports unless you really want to use it. For printable forms (using templates) or complex report, you may consider PL/PDF. It is simply a set of PL/SQL packages to be installed in its own schema in a database. You can call the PL/PDF output in a browser or save it into your custom table BLOB column – and sending it out as email attachment…for a price of $600 per database. If you only need to dump report data in apex, in addition to standard .csv output, into pdf, FOP (Apache+Cocoon) should be good enough…as long as you do not require a fancy template. I customized the default XSL template and used it for different reports in one of my apex application …
Re: print tool in APEX 2006/12/18
Hi User…. APEX does not have any built-it reporting capability. And no, this is not a bug; robust reporting is a big issue that is usually handled by third party reporting tools. In an APEX environment you have a number of options: - Export your data to a CSV file and then open the CSV file with your favorite reporting tool (MSExcel, MSAccess, Crystal Reports, Oracle Forms, Oracle Discovery etc). - Since your APEX data is already in an Oracle Database, you can create views that are tailored to your reporting needs and then expose them to your favorite reporting tool via ODBC, OLE etc. - Search this forum for “PDF” or “PLPDF”. The search will lead you to lots of links that tell you how to use a PL/SQL package to generate PDF files directly out of APEX. - Write your own PL/SQL routines that generate XML. Oracle 10g contains one or more PL/SQL packages that help with this task. Search this forum and the 10g database forum for “XML”. Other forum users may have other suggestions …
Re: Standalone BI Publisher now available for Windows 2007/05/21
Tony, I “think” the easiest way to get PDF output at a cheap price is going to be PL/PDF (http://plpdf.com). It looks like it costs $500, and I don’t see any other software requirements, since it works with mod_plsql. The coccon and other “stuff” is free, but I don’t know how difficult it is to get setup and running. I’m also not sure how much leeway you get in designing your output. Since PL/PDF is generated by code you write with PL/SQL packages, I imagine that you can get some pretty customized output that would exactly fit your needs. When I first heard Apex 3.0 would allow PDF output, I was hoping that there was some kind of unannounced deal where Oracle had bought the company and was going to include the PL/PDF packages as some of their “standard” packages, like DBMS_OUTPUT. At least since they haven’t done it yet, there may still be some hope that maybe someday they will, but then I don’t see where that would really benefit the BI Publisher market, though I no idea how b …
Re: About choosing APEX for database application development project 2009/05/02
Hi, OK – I’ve responded to your other thread with some suggestions for you. There are a number of add-ons you can use. I use FireFox with Web Developer and FireBug (which is the most useful tool there is). There are others that allow you to control the look of the Apex definition pages themselves (for example, you can fix the height of textareas) but I don’t use this (it is a generic tool rather than one specific for Apex but allows you to override the css styling for objects on a site’s page). Web Developer helps debugging css/javascript and FireBug helps with the html page structure as well as with styling – it also has features that allow you to track how long page components take to load (very useful if there appears to be a problem somewhere). There are equivalents for IE – I have used them, but that was a while ago and I can’t recall their names. For my apps, the user just prints the report using the normal File/Print on the browser or exports the data and formats them wit …
Re: Latest Poll 2006/11/01
Here is my use case for PDF reports… We are proposing an online account inquiry system to a large financial company. They currently use our back office accounting system, but use a third party vendor’s system to allow customers to access their accounts. It is extremely slow and expensive to customize. It only took a couple hours to make a proof of concept, and a couple of days to make a decent prototype of a replacement in Apex. It is, of course, lightning fast. The only thing missing is customer account statements in PDF format. I made a sample in HTML/CSS, but they need to allow the customers to download them as PDF files. We can’t rely on end users to have a PDF printing package installed. Being able to archive or email PDF reports would be a plus. There are ways to produce PDFs on the server, including PLPDF and FOP. Large companies often will not accept any open source software, so that rules out FOP. Thinking out loud now… Like Arie says, the current report engin …
Re: Printing out a report in Apex 2008/05/23
Prohan, I have never been able to get PDF generation working from APEX. I have asked for some help on this forum, but go no responses. And I just won’t spend the outrageous license fees for Oracle BI Publisher. But I have been successful in doing what need with some simple methods. 1. If the email has some simple tables or formatted information from the database, use a PL/SQL procedure to generate an HTML formatted message and the utl_mail package to send the html formatted email. I use this for many customer and internal emails from both APEX and Oracle Forms applications. 2 There is a stand-alone product PL/PDF (http://www.plpdf.com/) that allows you to generate PDF files directly from PL/SQL (again not APEX specific). I have demoed this product and it works pretty well, but I am not using it at this time because of the licensing that requires a fee for each database instance. It’s not really that expensive, but it’s more than I want to spend for the number of databases I have. 3 …
Re: 3.0.1 Migration from Ver HTMLDB 2.0 2008/02/13
Hello Bjorn, >> 1. One of our old apps had a custom background template, nothing special, all it did was match the background colour to the background colour of our forms and tables(reports), The background of the app is now white. Any pointers on where to go looking to change this? The upgrade process doesn’t change any existing template in any existing applications (in order of doing that you need to upgrade the application theme – http://forums.oracle.com/forums/message.jspa?messageID=2342965#2342965). Do you see this custom template in the template list? Is the background color being set as part of the HTML code or with the CSS file? Do you use a custom CSS file? >> 2. Its probably just because we were use to HTMLDB 2 but dose any one else find the user interface more complex? It just seemed clearer to find things on the old interface. The complexity of the user interface is surly a subjective issue. Don’t forget that the later versions added a lot of new featu …
Re: Is there an inexpensive APEX report printer for invoices/checks/statements? 2009/06/11
if you look at http://www.plpdf.com/simple_examples.html syntax used is almost same other than the package name. here is what i did( this is part of the code to give you idea ) *********** BEGIN FOR rec1 in cur1 loop l_comments := rec1.value_id; END LOOP; FOR rec2 in cur2 loop l_strengths := rec2.value_id; END LOOP; FOR rec3 in cur3 loop l_area_to_address := rec3.value_id; END LOOP; –reset page margin pl_fpdf.SetXY(pl_fpdf.GetX-4.5,pl_fpdf.GetY); pl_fpdf.SetLeftMargin(pl_fpdf.GetX); pl_fpdf.line(pl_fpdf.GetX,pl_fpdf.GetY+.5,pl_fpdf.GetX+12.625,pl_fpdf.GetY+.5); pl_fpdf.Text(pl_fpdf.GetX,pl_fpdf.GetY+.75,’Comments:’); pl_fpdf.SetXY(pl_fpdf.GetX+.25,pl_fpdf.GetY+.875); pl_fpdf.MultiCell(12.325,.25,l_comments,0,’L',0,0); pl_fpdf.SetXY(pl_fpdf.GetX,pl_fpdf.GetY+.5); pl_fpdf.line(pl_fpdf.GetX,pl_fpdf.GetY,pl_fpdf.GetX+12.625,pl_fpdf.GetY); pl_fpdf.SetXY(pl_fpdf.GetX,pl_fpdf.GetY); …
Re: flash recovery area backup sets 2010/05/14
What should I do with the following statistics? Thanks. Andy SQL> show parameter db_recovery_file_dest_size NAME TYPE VALUE ———– db_recovery_file_dest_size big integer 104857600000 SQL> C:\Documents and Settings\achow>rman target / Recovery Manager: Release 11.1.0.6.0 – Production on Thu May 13 15:08:57 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: VRDS (DBID=1224812685) RMAN> list backup; using target database control file instead of recovery catalog List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time —- – ———– ————— 757 Full 15.60G DISK 00:03:15 13-MAR-10 BP Key: 757 Status: AVAILABLE Compressed: NO Tag: BACKUP_VRDS.IN.SFD _031310105809 Piece Name: E:\FLASH_RECOVERY_AREA_11\VRDS\BACKUPSET\2010_03_13\O1_MF_NN NDF_BACKUP_VRDS.IN.SFD_0_5SS29BX …
Re: flash recovery area backup sets 2010/05/14
What should I do with the following statistics? Thanks. Andy SQL> show parameter db_recovery_file_dest_size NAME TYPE VALUE ———– db_recovery_file_dest_size big integer 104857600000 SQL> C:\Documents and Settings\achow>rman target / Recovery Manager: Release 11.1.0.6.0 – Production on Thu May 13 15:08:57 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: VRDS (DBID=1224812685) RMAN> list backup; using target database control file instead of recovery catalog List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time —- – ———– ————— 757 Full 15.60G DISK 00:03:15 13-MAR-10 BP Key: 757 Status: AVAILABLE Compressed: NO Tag: BACKUP_VRDS.IN.SFD _031310105809 Piece Name: E:\FLASH_RECOVERY_AREA_11\VRDS\BACKUPSET\2010_03_13\O1_MF_NN NDF_BACKUP_VRDS.IN.SFD_0_5SS29BX …
Re: APEX Development and Reporting Tools 2009/07/23
I have also found a product called ApexSQL Developer Studio but this would appear to be SQL Developer toolset with a similar name but no link to APEX Indeed. That appears to be a product for use with SQL Server, with no relevance to Oracle or Application Express. In terms of Reporting tools, Oracle BI Publisher is Oracle’s recommended tool, but its licensing costs are an issue for many people. Other reporting solutions that are widely discussed are: Apache FOP Oracle Reports PL/PDF Jasper Reports BIRT Suggest searching the forum to find out about user’s experiences with these, and for reasons on deciding which are appropriate to your requirements. As for development tools, my personal preferences and recommendations would be: Oracle SQL Developer for working with SQL and PL/SQL. Although it’s possible to use the APEX SQL Workshop to query the database, write PL/SQL, and maintain DB objects using just a web browser, I prefer to use SQL Developer. It’s free, I like the UI in compar …
Permissions to external Jar for reading-writing on a file 2008/10/30
hi all,I explain my situation.I ‘ ve made an open source project similar to plpdf using jasper report libraries and others.My project, which works perfectly in a java jre, have some problems in Oracle Aurora jvm.I use the Reflection technique to load the classes from their libraries.For this i use this class :java.lang.reflect.InvocationTargetExceptionat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java)at java.lang.reflect.Method.invoke(Method.java)at org.Reflection.Utility.executeMethod(Utility.java)at org.EngineReport.ReportControl.compileJrxml(ReportControl.java:44)at org.EngineReport.ReportOracle.getReportByte(ReportOracle.java:130)at org.EngineReport.ReportOracle.ReportAsBlob(ReportOracle.java:69)at org.EngineReport.ReportOracle.ReportAsBlob(ReportOracle.java:49)Caused by: java.security.AccessControlException: t …