Apex on OCI AF: 22.1
Hello!
How do we raise/record/force errors to show up under Error Rows in Execution Log when running automation? Currently, the log_error call records an error under Execution Log\Messages, but nothing gets recorded under Execution Log-> Error Rows. An example screen prints shows 7 rows executed. One of them had error recorded, but they are not registered under Error Rows.
The process I am running is a procedure that calls REST + subsequent processing+verification etc. This procedure is typically called many times for each rest source. Rows provided to automation are metadata needed to run the procedure. Desired behavior when an error occurs is to record the error and move to the next call/row. The code has been instrumented with apex_automation.log_error calls and ora error is raised to stop any further processing for the action.
I tried to play with error handling settings under automation and oracle exceptions, but no luck showing Errors under Error Rows.
My current setup is as follows:
Automation setup:
Type=On-demand, Actions Initiated On=query, Data Source=Local Database, Source Type=SQL Query.
One action defined = Execute Code. Under error handling: stop execution on error = Off. I want to record error on row and proceed to the next row to process.
Execute Actions when= rows returned, commit=each row, action error handling = abort automation
Thank you for reading the essay!