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!

apex commit

RNJun 17 2011 — edited Jun 17 2011
I read experts comments on when apex issues commit. But still have a question:

I have pl/sql process which runs at "On submit and before computation". It does not change any session state. It just includes direct insert and update statements.

I am not issuing any explicit commit. And things seem to be working fine-I mean DMLs are being auto committed in any case.

But still want to get my question answered:

If a validation fails or if another process which is fired at "After submit" fails , will the insert and update statements be still committed?

In what scenario, the DMLs will not be committed?


Regards,
RN
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2011
Added on Jun 17 2011
9 comments
882 views