Is there available OBE, demo, tutorial for this task?Nope. This is something I developed on my own -- not a 'Code by Google' special. It wasn't a cakewalk to build, but not extraordinarily difficult either. PDFTK uses FDF files to fill forms. FDF files are text-based, and so can be manipulated by PL/SQL. They contain the field name (i.e. 'FIRST_NAME'), and the value to be placed into that field. I create an FDF 'template' with the fields filled in with formatted replacement text (i.e. '#FIRST_NAME#'). This, along with the unfilled PDF form are saved to a directory accessible to Oracle. The actual 'code' process performs the following steps:
Is the link given by Tony same process you have done?Nope. Completely different animals.
...or which of the two is easier and better? effective & efficient ?Of the options listed in this thread, PL/PDF is probably easiest and most flexible. The only thing my method has to offer is that is it completely free since PDFTK is freeware. Since you have to write the interface on your own to use it, making use of PDFTK will be harder to implement. Filling in PDF forms is very much a minor (albeit handy) feature of my apps. It automates some functionality that used to be performed manually by our billing team. I wasn't sure when I started that I would be able to get PDFTK to do what I wanted... but I like challenges. :)