BILL Carlisle
asked on
APEX - Transaction Control - Commit/Rollback
Hi, I'm using Oracle Application Express which has Auto commit...
If I want to have the update on a form and update of a xref table to both succeed or fail then would I just have from the APEX process to a database procedure or function call and just have a PL/SQL block with commit at the end and a rollback in the exception handling?
If I want to have the update on a form and update of a xref table to both succeed or fail then would I just have from the APEX process to a database procedure or function call and just have a PL/SQL block with commit at the end and a rollback in the exception handling?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER