apex_add_process
Add an Oracle APEX page process: execute PL/SQL blocks, perform DML on tables, or redirect using a branch, with configurable execution order and conditions.
Instructions
Add a page process: PL/SQL block, DML on table, or branch redirect.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| point | No | When to execute: - "AFTER_SUBMIT": After page submission (default) - "BEFORE_HEADER": Before page header renders - "ON_SUBMIT_BEFORE_COMPUTATION": Very early in submit | AFTER_SUBMIT |
| source | No | PL/SQL source for plsql/ajax types. | |
| page_id | Yes | Page ID. | |
| sequence | No | Execution order. | |
| table_name | No | Table name for dml type (e.g., "MY_TABLE"). | |
| process_name | Yes | Process display name. | |
| process_type | No | Type of process: - "dml": Automatic DML (INSERT/UPDATE/DELETE based on form items and table). Requires table_name. Auto-handles PK detection. - "plsql": Custom PL/SQL block (use source param). - "ajax": AJAX Callback (accessible via apex.server.process()). Use for auto-save, search, etc. - "close_dialog": Close modal dialog. - "clear_cache": Clear page cache. | dml |
| error_message | No | Custom error message on failure. | |
| return_pk_item | No | Page item to store the returned primary key (for INSERT). | |
| success_message | No | Message shown on success. | |
| condition_button | No | Button name that triggers this process (e.g., "SAVE"). Empty = runs on any submit. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |