原帖子见下,等有空了再翻译吧。(估计没有空)
核心要点如下:
A commit is a commit -- it commits all outstanding work and cannot be undone. The entire purpose, goal and only meaning of commit is to make changes permanent.
The "nesting" of procedures has nothing to do with this behavior. Whether you coded in a linear fashion (no procedures) or modular -- the effect would be the same. Commit -- and the data is committed, will not be rolled back.
嵌套调用存储过程和commit行为没有什么直接关系,不论是从上而下的线性代码还是模块化代码,对于commit来说效果都是一样的,commit以后就不会再rollback。
https://asktom.oracle.com/pls/apex/asktom.search?tag=nested-stored-procedures