Solved

Merging of PDFs stored in database

Posted on 2014-10-22
2
263 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Currency in SQL? 2 32
minium over 4 numeric columns for each row in oracle 2 29
SQL Recursion 6 20
SQL Recursion schedule 13 19
Read about achieving the basic levels of HRIS security in the workplace.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

821 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