Products

Our products target issues that exist because there is no easy way to solve them using the standard Oracle database package or products available on the internet. Below aresome issues from Oracle blogs and our products to solve the issues.

PL/PDF Toolkit

Issue 1: Merge multiple PDF docs into one PDF

"hi,I would like to merge multiple PDF docs into one PDF in a stored procedure."

Solution for issue 1.

PL/PDF Toolkit is a Java library with PL/SQL interface for manipulating existing PDF documents.

Features

PDF Encrpytion/Decryption
PDF Metadata manipulation
Extraction of text from PDF
Merging PDF documents
Replacement of URLs in a PDF document
Stamp content or watermark into a PDF document

PL/XLS

Issue 2: Excel generation through PL/SQL

"Please let me how to generate an excel from a PLSQL package or procedure. i have data in a cursor and now i want to populate the data into an excel sheet and format the excel sheet also."

Issue 2: Load Excel data

"Is there any way whereby I can automate the loading of data from an excel spreadsheet into my database? The only way we know is to manually export the data into an ascii file and then load it into the database using sqlload."

Solution for issues 2. and 3.

PL/XLS is a product that can produce Excel XML documents from data in an Oracle database as well as load data from Excel spreadsheets into an Oracle database.