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?
BILL CarlisleAPEX DeveloperAsked:
Who is Participating?
sdstuberConnect With a Mentor Commented:
yes, that's exactly how you should do it,  you can invoke your procedure on submit before or after validations and before or after other processes for the page
BILL CarlisleAPEX DeveloperAuthor Commented:
Thanks for the confirmation Sean!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.