Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rollback all process if raise_application_error is invoked

Fahd BahooOct 10 2019 — edited Oct 14 2019

Apex 5.1.4

Database 11.2

i have three process in my page. The last process can raise error pragmatically by using RIASE_APPLICATION_ERROR. The first two process are inserting data in some tables, last process is verify the data, if there is something wrong then i am raising error.

But the problem is that, it raises the error but data inserted by previous process is not rolled back, so i have Partial Transaction Problem.

Can any body help ?

pastedImage_1.png

This post has been answered by Carsten Czarski-Oracle on Oct 10 2019
Jump to Answer
Comments
Post Details
Added on Oct 10 2019
10 comments
1,400 views