apex_generate_rest_endpoints
Generate ORDS REST endpoints (GET, POST, PUT, DELETE) for an Oracle table, with options for schema, base path, and authentication.
Instructions
Generate ORDS REST endpoints (GET/POST/PUT/DELETE) for a table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Database schema. Resolved via SELECT USER FROM DUAL if omitted. | |
| base_path | No | URL base path segment (e.g. "orders"). Defaults to table_name in lowercase. The final module base path will be "/{base_path}/". | |
| pk_column | No | Primary key column name. Auto-detected from user_constraints (type='P') if omitted. | |
| table_name | Yes | Name of the table to expose via REST (case-insensitive). | |
| require_auth | No | Whether to mark the module as requiring authentication. Currently used for documentation; ORDS privilege assignment must be configured separately in ORDS Admin. Defaults to True. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |