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

ITPub博客

Difference between Commit,COMMIT_FORM and Do_Key('Commit_Form')

最新文章