05 / Developer tooling

Audit Change Tracking Framework

A reusable Oracle auditing framework that generates consistent change tracking for any table in a schema.

View source Oracle / PL/SQL / SQL / Automation

Project preview

The challenge

Enterprise systems need clear data histories, but hand-writing triggers for every table is repetitive and difficult to maintain.

What I built

Dynamic trigger generator for INSERT, UPDATE, and DELETE events
JSON-aware audit payloads and configurable auditing
Query-friendly reporting views, indexing, and partitioning support

Technical approach

Oracle packages generate table-specific triggers that call shared audit logic. Audit records and configuration tables are exposed through reporting views, with JSON payloads available for richer change inspection.

Key decisions

Generate repetitive triggers from metadata instead of copying handwritten implementations.
Centralize change handling in packages for consistent validation and retention rules.
Support indexed and partitioned audit storage for operational reporting at scale.

Demo status

Source available. A hosted demo is not planned because it requires an Oracle database environment.