Link to home
Start Free TrialLog in
Avatar of BILL Carlisle
BILL CarlisleFlag for United States of America

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?
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BILL Carlisle

ASKER

Thanks for the confirmation Sean!