PL_FPDF

Pure PL/SQL PDF Generation & Manipulation Library

Installation • Quick Start • Features • Docs • Portugues

📌 About this project: This is a fork of Pilooz/pl_fpdf — the original PL/SQL port of FPDF by Pierre-Gilles Levallois — actively maintained, modernized and extended by @maxwbh: Oracle 19c/23c support, UTF-8/TrueType, PDF manipulation (v3.0), RC4 encryption (v3.2) and tooling.

Generate and manipulate PDFs directly in Oracle Database - no Java, no external services, no middleware.

-- Option 1: Run deployment script
@deploy_all.sql

-- Option 2: Install manually
@src/PL_FPDF.pks
@src/PL_FPDF.pkb

-- Verify
SELECT PL_FPDF.co_version FROM DUAL;
-- Returns: 3.2.0

Requirements: Oracle 19c+ | No external dependencies

DECLARE
  l_pdf BLOB;
BEGIN
  PL_FPDF.Init('P', 'mm', 'A4');
  PL_FPDF.AddPage();
  PL_FPDF.SetFont('Arial', 'B', 16);
  PL_FPDF.Cell(0, 10, 'Hello World!', '0', 1, 'C');
  l_pdf := PL_FPDF.Output_Blob();
END;

DECLARE
  l_pdf BLOB;
BEGIN
  SELECT pdf_blob INTO l_pdf FROM documents WHERE id = 1;

  PL_FPDF.LoadPDF(l_pdf);
  PL_FPDF.RotatePage(1, 90);
  PL_FPDF.AddWatermark('CONFIDENTIAL', 0.3);
  PL_FPDF.RemovePage(3);

  l_pdf := PL_FPDF.OutputModifiedPDF();
END;

DECLARE
  l_pdf BLOB;
  l_perms JSON_OBJECT_T := JSON_OBJECT_T();
BEGIN
  l_perms.put('print', TRUE);
  l_perms.put('copy', FALSE);

  l_pdf := PL_FPDF.EncryptPDF(
    p_pdf            => l_original,
    p_user_password  => 'user123',
    p_owner_password => 'owner456',
    p_permissions    => l_perms,
    p_encryption     => 'RC4-128'
  );
END;

DECLARE
  l_merged BLOB;
BEGIN
  PL_FPDF.LoadPDFWithID(l_pdf1, 'doc1');
  PL_FPDF.LoadPDFWithID(l_pdf2, 'doc2');
  l_merged := PL_FPDF.MergePDFs('doc1,doc2');
END;

• Multi-page documents (unlimited pages)
• Text, shapes, images (PNG, JPEG)
• TrueType fonts with UTF-8
• Barcodes (Code39, EAN-13, QR Code)
• Tables with auto-pagination

• Load and parse existing PDFs
• Rotate pages (0, 90, 180, 270)
• Remove pages
• Add watermarks (text/image)
• Text and image overlays
• Merge multiple PDFs
• Split PDF by page ranges

• RC4 40-bit encryption (legacy)
• RC4 128-bit encryption (standard)
• Password protection (user/owner)
• Permission controls (print, copy, modify, etc.)
• PDF decryption

• Pure PL/SQL (no external dependencies)
• Package-only (no tables, types, or sequences)
• Oracle 19c compatible (guaranteed)
• Native compilation support (2-3x faster)

pl_fpdf/
│
├── src/                          # Source Code
│   ├── PL_FPDF.pks              # Package specification (79 KB)
│   └── PL_FPDF.pkb              # Package body (355 KB)
│
├── extensions/                   # Optional Extensions
│   └── brazilian-payments/      # PIX QR Code & Boleto
│       ├── packages/            # PL_FPDF_PIX, PL_FPDF_BOLETO
│       └── tests/
│
├── tests/                        # Test Suite (25+ tests)
│   ├── run_all_tests.sql        # Run all tests
│   ├── test_phase_*.sql         # Feature tests
│   └── validate_phase_*.sql     # Validation scripts
│
├── scripts/                      # Utilities
│   ├── optimize_native_compile.sql
│   └── recompile_package.sql
│
├── docs/
│   └── DOCUMENTATION.md         # Complete documentation
│
├── .github/                      # GitHub Templates
│   └── ISSUE_TEMPLATE/
│
├── README.md                     # This file
├── README_PT_BR.md              # Portuguese version
├── CHANGELOG.md                 # Version history
├── CONTRIBUTING.md              # How to contribute
├── SECURITY.md                  # Security policy
├── CODE_OF_CONDUCT.md
└── deploy_all.sql               # Deployment script

See CHANGELOG.md for full history.

1. Fork the repository
2. Create feature branch (git checkout -b feature/amazing)
3. Follow coding standards
4. Add tests
5. Submit Pull Request

See CONTRIBUTING.md for details.

• FPDF (PHP): Olivier PLATHEY
• Original PL/SQL Port: Pierre-Gilles Levallois (Pilooz/pl_fpdf), Anton Scheffer
• This fork — Modernization & v2.x/v3.x: Maxwell da Silva Oliveira (@maxwbh)

MIT License - see LICENSE

Star on GitHub • Report Issue • Contact