Solved

Merging of PDFs stored in database

Posted on 2014-10-22
2
250 Views
Last Modified: 2014-11-03
I have setup the database which holds info about customers orders and those orders are saved in form of PDFs and/or TIFFs in the database per client.

As part of monthly business procedures, it is required that all invoices for one customer need to be joined in one file and stored as a monthly file in PDF/a format in the database for the archiving purposes.

So, the issue here is that i need to create/implement some kind of automation where this merging will be done by running some SQL procedure.

How can i achieve this? Or is this even possible?
0
Comment
Question by:Haris Djulic
2 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 500 total points
ID: 40398547
>> where this merging will be done by running some SQL procedure.

I'm afraid, this process cannot be done via sql, infact I would say that file is an external object which would reside in operating system, so its better to go for other options outside of database..

Oracle BI Publisher(needs license if you want to use it for commercial/business purposes) has a facility to do so.. but I have never done this kind of thing.. But I am sure that its out of the box utility for oracle database.. You have to create external libraries and point them to your library path and build procedures around them to wrap them as a oracle object and can use them via sql.. but trust me its a tedious process..


>>How can i achieve this? Or is this even possible?

Refer to the Oracle Documentation of book binding(merging documents) using BI Publisher

http://www.oracle.com/technetwork/middleware/bi-publisher/bip-bookbinding-176639.pdf
0
 
LVL 15

Author Closing Comment

by:Haris Djulic
ID: 40421010
Thanks, this is good starting point for what i need..
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
PL/SQL - Leading zeros 7 42
how to fix this error 14 48
SQL Select Query help 3 32
Slow SQL query 12 29
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now