Introducing PL/ACROFORM: Extract, Fill and Flatten PDF Forms in Oracle

PL/ACROFORM v0.7.0 is now available!

The newest member of the PL/ family brings PDF form extraction, filling, and flattening directly into Oracle Database through a focused PL/SQL API.

Many business processes still depend on fillable PDF documents. PL/ACROFORM makes it possible to process these forms automatically, exchange data as JSON, and prepare completed PDFs without relying on an external document-processing service.

What is PL/ACROFORM?

PL/ACROFORM is an Oracle PL/SQL component for processing existing PDF AcroForms stored as BLOBs.

It provides three core operations:

* EXTRACT — Read PDF form field names and values into JSON.
* FILL — Populate existing PDF forms using JSON data.
* FLATTEN — Convert completed interactive forms into static PDF documents.

Applications can retain editable PDF fields or produce a static final document, depending on the workflow.

Key features

* JSON-based form data extraction — Extract field values while preserving their original identifiers.
* Automated PDF form filling — Populate existing forms without rebuilding the document layout.
* Multiple field types — Support text fields, checkboxes, radio buttons, choice fields and multi-select values.
* Appearance generation — Create visible field appearances for completed PDF forms.
* Static PDF output — Flatten forms while retaining their visible content.
* One-pass fill and flatten — Populate and flatten a PDF in one operation, with a single PDF save.
* Oracle-native integration — Work directly with Oracle BLOBs, CLOBs, PL/SQL packages and APEX applications.

Practical use cases

Vendor onboarding and tax forms

Automatically populate standardized documents, including W-9 forms, using information already available in Oracle Database.

Customer and employee forms

Extract submitted PDF form data into JSON for database storage, validation and approval workflows.

Automated document preparation

Generate completed PDF forms through scheduled database jobs or application processes.

Oracle APEX applications

Integrate PDF form processing into existing APEX workflows without introducing a separate document server.

Document archiving and distribution

Convert completed forms into static PDF documents suitable for downstream processing and long-term records management.

A simple PL/SQL API

PL/ACROFORM exposes just three public functions: extract(), fill() and flatten().

The new pl_flatten => TRUE option allows fill() to populate a PDF and immediately convert its form fields into static page content, without saving and reopening an intermediate PDF.

The included demo uses an interactive W-9 PDF and demonstrates all three functions with sample data.

Built for Oracle developers

PL/ACROFORM fits naturally into existing PL/SQL packages, Oracle APEX applications and database-driven document workflows.

Version 0.7.0 focuses on PDF AcroForms. XFA processing is outside its current scope, and flattening is not intended as secure data redaction.

Get started

Explore the features, review the User Guide, and request the PL/ACROFORM evaluation kit and W-9 demo.

PLslash
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.