Merging of PDFs stored in database

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?
LVL 15
Haris DulicAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wasim Akram ShaikCommented:
>> 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Haris DulicAuthor Commented:
Thanks, this is good starting point for what i need..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.