Skip to content

uc-apx create process execute-code

Splice a process ... type: executeCode source { plsqlCode: ... } into a page. Identical to create process plsql; the name matches the MMD type for discoverability.

uc-apx create process execute-code [flags]
FlagTypeDefaultDescription
--codestringPL/SQL body to run (literal text or @path/to/file.sql to read from disk) [required]
--dry-runPrint rendered process to stdout without writing
--idstringOverride the construct id (default: kebab-case of —name)
--namestringDisplay name of the process [required]
--pagestringTarget page (numeric ID, alias, or name) [required]
--pointstringbeforeHeaderexecution.point: afterAuthentication, afterComputation, afterFooter, afterHeader, afterLogout, afterProcessing, afterRegions, afterSubmit, afterValidations, beforeComputation, beforeFooter, beforeHeader, beforeLogout, beforeProcessing, beforeRegions, beforeValidations, onLoad, onSubmit, processing, validation
--sequenceintexecution.sequence (default: max existing process sequence at this point + 10)
--server-side-conditionstringOptional serverSideCondition body, e.g. “requestIsContainedInValue=CREATE,SAVE”
FlagTypeDefaultDescription
--app-dirstring.Path to the APEX application directory
--json-prettyOutput in pretty-printed JSON (human-readable) instead of minified JSON
--toonOutput in TOON format (human-readable, token-efficient) instead of JSON
Terminal window
uc-apx create process execute-code \
--page 71 \
--name "Count Clicks" \
--code "insert into eba_cust_clicks (cust_id) values (:P71_ID);" \
--point beforeHeader

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

Terminal window
uc-apx --app-dir examples/brookstrut create process execute-code --page 46 --name Init Filter --code :P46_SEARCH := nvl(:P46_SEARCH, '%'); --point beforeHeader --dry-run
Generated APEXlang
process init-filter (
name: Init Filter
type: executeCode
execution {
sequence: 20
point: beforeHeader
}
source {
plsqlCode:
```plsql
:P46_SEARCH := nvl(:P46_SEARCH, '%');
```
}
)