Handle All Errors in One Place in Oracle APEX: Error Handling Function and Error Log
One table, one PL/SQL function, and one application setting give central error handling and an Error Log page for any Oracle APEX app.
Oracle APEX
Oracle APEX (Application Express) is a low-code development platform for building scalable, secure enterprise applications. It allows developers to quickly create web-based applications using a browser-based interface, reducing the need for extensive hand-coding.
For a more structured learning journey, you can also explore the Oracle APEX Roadmap for a sequential path through related concepts, features, and development topics.
Tally-Style Drill-Down Reports in Oracle APEX with Keyboard Navigation
Three levels of Classic Reports and a dialog, with one small JavaScript file for Tally-like keyboard navigation, a sticky grand total, and a Print button.
How to Track Who Changed What in Oracle APEX: A Change History for Any Table
One history table, a small package that creates the trigger for any table, and a Classic Report region that shows who changed what.
How to Make an Item Read Only in Oracle APEX Without Losing Its Value
A short, step-by-step fix for disabled form items that save as empty or fail with a required error, with a readable read-only style.
Mask Sensitive Data in Oracle APEX with Oracle Data Redaction (DBMS_REDACT)
A step-by-step guide to masking personal data by role in Oracle APEX with DBMS_REDACT, an application context, and fixes for the form and filter traps.
Row-Level Security in Oracle APEX with VPD: Show Each User Only Their Own Data
A step-by-step guide to showing each Oracle APEX user only their own rows with Virtual Private Database, one policy function, and no WHERE clauses in the pages.
How to Build Electronic Signatures in Oracle APEX: A Free DocuSign Alternative with a Digital Seal
A step-by-step guide to signing PDFs in your own Oracle APEX schema, with one-time codes, an immutable audit trail, a digital seal, and any PDF tool.
How to Manage an APEX Instance and Generate Test Data from PL/SQL
A tested guide to APEX_INSTANCE_ADMIN, APEX_APPLICATION_ADMIN, APEX_UI_DEFAULT_UPDATE, APEX_DB_DICTIONARY, and APEX_DG_DATA_GEN in APEX 26.1.
How to Export and Install APEX Applications Using APEX_EXPORT and APEX_APPLICATION_INSTALL
A tested guide to APEX_EXPORT, APEX_APPLICATION_INSTALL, and APEX_APP_OBJECT_DEPENDENCY in Oracle APEX 26.1, for scripts and CI pipelines.
How to Build APEX Plug-ins in PL/SQL Using APEX_PLUGIN and APEX_PLUGIN_UTIL
A tested guide to APEX_PLUGIN and APEX_PLUGIN_UTIL in Oracle APEX 26.1, from render callbacks and Ajax to data, substitutions, and REST sources.
How to Call Generative AI and Search from PL/SQL Using APEX_AI and APEX_SEARCH
A tested guide to APEX_AI, APEX_SEARCH, APEX_SPATIAL, and APEX_PWA in Oracle APEX 26.1, from prompts and chats to search, maps, and push.
How to Create Tasks and Run Workflows from PL/SQL Using APEX_HUMAN_TASK and APEX_WORKFLOW
A tested guide to APEX_HUMAN_TASK, APEX_WORKFLOW, APEX_AUTOMATION, and APEX_BACKGROUND_PROCESS, from approval tasks to workflows and schedules.
How to Filter and Reset Interactive Reports and Grids from PL/SQL Using APEX_IR and APEX_IG
A tested guide to APEX_IR and APEX_IG in Oracle APEX, from adding filters in page processes to resetting, cloning, and reassigning saved reports.
How to Handle Errors, Debug, and Translate Messages Using APEX_ERROR and APEX_DEBUG
A tested guide to APEX_ERROR, APEX_DEBUG, and APEX_LANG in Oracle APEX, from inline errors and error handling to debug logs and translations.
How to Send Emails, Print Documents, and Create Barcodes Using APEX_MAIL and APEX_BARCODE
A tested guide to APEX_MAIL, APEX_PRINT, and APEX_BARCODE in Oracle APEX, from queued emails and templates to documents, QR codes, and barcodes.
How to Manage Sign-In, Roles, and Authorization from PL/SQL in Oracle APEX
A tested guide to APEX_AUTHENTICATION, APEX_AUTHORIZATION, APEX_ACL, APEX_CUSTOM_AUTH, and APEX_LDAP, from login to roles and directories.
How to Call REST APIs from PL/SQL Using APEX_WEB_SERVICE
A tested guide to APEX_WEB_SERVICE, APEX_CREDENTIAL, APEX_JWT, and APEX_HTTP, from REST calls and uploads to credentials and JSON Web Tokens.
How to Export Data to PDF and Excel and Load Files Using APEX_DATA_EXPORT
A tested guide to APEX_DATA_EXPORT, APEX_DATA_LOADING, and APEX_REST_SOURCE_SYNC, from exporting and downloading files to loading and syncing data.