Audit & Error Logging Templates for Oracle APEX

What this is

A small set of production-ready Oracle APEX / PL-SQL templates that solve two problems every application has:

• Knowing who did what, and when
• Capturing errors with enough context to debug quickly

These are infrastructure building blocks, not frameworks.

What’s included

1️⃣ Audit Logging Template

Tracks user actions in a consistent, queryable way.

• Logs who, what, when, and where
• Simple PL/SQL API (APP_AUDIT.log_event)
• Optional trigger example
• No UI, no reports, no abstractions

2️⃣ Error Handling & Logging Template

Standardizes how your application records technical failures.

• Centralized error log table
• PL/SQL logger (APP_ERROR.log_error)