uc-apx create dynamic-action execute-plsql

Splice a dynamicAction with a single executeServerSideCode action.

Pick exactly one trigger: —trigger-button @<id> — event defaults to click —trigger-item @<id> — event defaults to change (omitted in when block)

—code accepts inline PL/SQL or @path/to/file.plsql to slurp from disk. —items-to-submit CSV of items submitted before execution. —items-to-return CSV of items populated from bind variables after execution.

Usage

uc-apx create dynamic-action execute-plsql [flags]

Flags

Flag	Type	Default	Description
--code	string		PL/SQL body, or @path/to/file.plsql [required]
--dry-run			Print rendered dynamicAction to stdout without writing
--items-to-return	string		CSV of items to return (populate) after execution
--items-to-submit	string		CSV of items to submit before execution
--name	string		Display name (default: “Execute PL/SQL on <trigger>“)
--page	string		Target page (numeric ID, alias, or name) [required]
--sequence	int		execution.sequence (default: max existing dynamicAction sequence + 10)
--trigger-button	string		Button id (selectionType: button, event: click)
--trigger-event	string		Override the trigger event
--trigger-item	string		Page item id (selectionType: items)

Global Flags

Flag	Type	Default	Description
--app-dir	string	.	Path to the APEX application directory
--json-pretty			Output in pretty-printed JSON (human-readable) instead of minified JSON
--toon			Output in TOON format (human-readable, token-efficient) instead of JSON

Example Generated APEXlang

Using --dry-run to preview the generated construct (no files are written):

uc-apx --app-dir examples/brookstrut create dynamic-action execute-plsql --page 46 --name Log Navigation --trigger-button @reset --code null; -- log nav here --dry-run

Generated APEXlang

dynamicAction execute-plsql-reset (
        name: Log Navigation
        execution {
            sequence: 20
        }
        when {
            event: click
            selectionType: button
            button: @reset
        }

        action native-execute-plsql-code (
            action: executeServerSideCode
            settings {
                plsqlCode:
                    ```plsql
                    null; -- log nav here
                    ```
            }
            execution {
                sequence: 10
            }
        )

    )