<div>
Thanks, this is good starting point for what i need..
</div>


Thanks, this is good starting point for what i need..

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
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.<br />
<br />
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.<br />
<br />
How can i achieve this? Or is this even possible?
</div>
</div>


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?

Merging of PDFs stored in database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.