Automatic Row Processing (DML) automatically performing COMMIT?
On my wizard-built single row form page (Application Express 2.2.1.00.04), I have in the "Page Processing" area an "Automatic Row Processing (DML)" process, followed by other few custom processes.
I noticed that, in case of unhandled exception errors in the custom processes, rows inserted by "Automatic Row Processing (DML)" process are not rolled back.
Does this mean that DML statements automatically generated by built-in "Automatic Row Processing (DML)" process are immediatelly commited?
Is there a way to avoid that? Any workaround (excepting replacement with custom DML processes)?
I would like to have my entire page submit processing treated as as a SINGLE TRANSACTION.