Difference between Commit COMMIT FORM and Do Key 'Commit For

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

                COMMIT_FORM and COMMIT do the same thing, they apply any outstanding changes in the form to the DB and issue a DB-COMMIT.

DO_KEY('commit_form') executes the code which is written in your KEY-COMMIT trigger. If that trigger doesn't exist it does the same as COMMIT_FORM.

Oracle Application Developer Guide says:

Replace COMMIT with do_key('commit_form'), This routine raises the exception FORM_TRIGGER_FAILURE if there is an invalid record.

Sequence of Trigger Fire while Committing

•  KEY-Commit
•  Pre-Commit
•  Pre/On/Post Delete
•  Pre/On/Post Update
•  Pre/On/Post Insert
•  On-Commit
•  Post Database Commit

           

给我老师的人工智能教程打call！http://blog.youkuaiyun.com/jiangjunshow